I can't seem to get this working, and it should not be that tough?
Here what I am trying to do:
* get the number of form variables coming in
* loop through the number of variables coming in, and as each form
variable comes in, do a query
* store the results of the query in an another variable
I can't seem to figure out how to attach a "subscript" to a form
variable name.
Here is what is the kind of thing that is NOT working:
<cfloop index = "LoopCount" from="1" to="#form.num_vars#" step="1">
<cfquery name="GetOrg_#LoopCount#" ... >
select * from table
where ID = #form.ExpOrg_ID_#LoopCount##
</cfquery>
i have tried several variations, and they generate interesting errors.
if someone would be so kind as to map this out for me, I can get over
the hump.
TNX if you can help.
Rick.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337592
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm