>I've never seen myQuery.myColumn inside a query loop not return what it
>should. Got some sample code?
Below is some sample code - it shows the problem with CF7 (haven't tested it
with anything else).
Note, as you will see, this bug(?) means that with nested queries you should
*fully* scope the query variables, *not* leave off the query scope entirely.
-------------------
<cfset qryOne = QueryNew("FieldA,FieldB,FieldC")/>
<cfset QueryAddRow(qryOne)/>
<cfset QuerySetCell(qryOne,'FieldA','Record 1a')/>
<cfset QuerySetCell(qryOne,'FieldB','Record 1b')/>
<cfset QuerySetCell(qryOne,'FieldC','Record 1c')/>
<cfset QueryAddRow(qryOne)/>
<cfset QuerySetCell(qryOne,'FieldA','Record 2a')/>
<cfset QuerySetCell(qryOne,'FieldB','Record 2b')/>
<cfset QuerySetCell(qryOne,'FieldC','Record 2c')/>
<cfset QueryAddRow(qryOne)/>
<cfset QuerySetCell(qryOne,'FieldA','Record 3a')/>
<cfset QuerySetCell(qryOne,'FieldB','Record 3b')/>
<cfset QuerySetCell(qryOne,'FieldC','Record 3c')/>
<cfset qryTwo = QueryNew("wibble")/>
<cfset QueryAddRow(qryTwo)/>
<cfset QuerySetCell(qryTwo,'wibble','wibble')/>
<cfset QueryAddRow(qryTwo)/>
<cfset QuerySetCell(qryTwo,'wibble','wibble')/>
<cfset QueryAddRow(qryTwo)/>
<cfset QuerySetCell(qryTwo,'wibble','wibble')/>
<cfset QueryAddRow(qryTwo)/>
<cfset QuerySetCell(qryTwo,'wibble','wibble')/>
<cfoutput>
<cfloop query="qryOne">
<!--- All three of these work fine --->
<hr/>A:#FieldA# / B:#qryOne.FieldB# /
C:#qryOne.FieldC[qryOne.CurrentRow]#
<cfloop query="qryTwo">
<br/>
<!--- First one throws error, second one always refers
to first record, third one works --->
A:##FieldA## / B:#qryOne.FieldB# /
C:#qryOne.FieldC[qryOne.CurrentRow]#
</cfloop>
</cfloop>
</cfoutput>
-------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315088
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
