>okay good, so I wasn't going crazy. CF can't reference variables in the
>current row of a a parent query loop from within a nested query loop
>(but Bluedragon can)
Inside of another query, CF will treat the variable as simple string--much
like it would outside a cfloop query loop. There's 2 ways around this:
1) set a local variable before getting into the loop
2) use the query.currentRow to specify the position in the query.
This is the way CF has behaved for as long as I can remember. I usually use
#2 to do what I want:
<cfloop query="myQuery">
<cfloop query="myInnerQuery">
<cfoutput>#myQuery.column[myQuery.currentRow]#</cfoutput>
</cfloop>
</cfloop>
-Dan
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233145
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54