Just to throw out another solution, you can get the same result you
initailly tried by doing the following:
<cfloop query="getcs">
<cfset variables["row"&getcs.currentRow] = getcs.cscount />
</cfloop>
On Thu, May 28, 2009 at 7:58 AM, Peter Boughton <[email protected]> wrote:
>
>> 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:322860
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
