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