Peter make them lists. <Cfset names = valuelist(myquery.name)> etc then use
listgetat
----- Original Message -----
From: "Peter Theobald" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, September 26, 2000 8:42 PM
Subject: Cant nest CFLOOPs !
> I just found out that if you nest CFLOOPs with Queries the inner CFLOOP
will undo the outer loops query variable bindings!
>
> In other words:
>
> <CFLOOP QUERY="myquery">
> name is #myquery.name# (this works)<br>
> <CFLOOP QUERY="liststates">
> state is #liststates.state# (this works)<br>
> name is #myquery.name# (this DOES NOT WORK!) It always shows the
FIRST RECORD of myquery!<br>
> </cfloop>
> </cfloop>
>
> Can this be?! In my real-world program my outer loop is querying a table
with 30 fields! Do I actually have to put them all in temporary variables in
order to "pass" them down into the inner loop? This stinks!
>
>
> --------------------------------------------------------------------------
-
> Peter Theobald, Chief Technology Officer
> LiquidStreaming http://www.liquidstreaming.com
> [EMAIL PROTECTED]
> Phone 1.212.545.1232 x204 Fax 1.212.679.8032
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
