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.