Trying to create a loop to create a dynamic query for me, but I’m getting lost.
what I want to do is something like this…
<cfloop index="i" from="1" to="27">
<cfset varQuery = "'#form.'" & i & #'">
</cfloop>
as you can guess coldfusion isn’t happy with what I’m trying, and I don’t know how to make it that on each reiteration of the loop, that varQuery is concatenated to the end of the already existing string.
The single quotes are in there on purpose. It’s text I am attempting to insert into the table. I was kind of hoping that because the # and single quotes were inside a double quotes it would be read as just a string…
You help would be much appreciated.
