> I need to store every row
> into a different distinct variable.
You probably don't, and should instead be using an array.
MyValues = ListToArray( ValueList( MyQuery.ColumnName ) )
Then you can do MyValues[1] to MyValues[9] to get at the variables.
If you *really* need to create individual variables, you can then do:
<cfloop index="i" from="1" to="#ArrayLen(MyValues)#">
<cfset Variables['MyVariable#i#'] = MyValues[i] />
</cfloop>
But don't do that - use the array.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322856
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
