Jeff D. Chastain wrote:
> I was referring to the inner query using the full scoped name -
> variables.queryName.
>
> So, why does setting newQueryName = variables.queryName PRIOR to looping
> the first query change anything? Both variables are in the variable
> scope and are created prior to the first loop - they should be the same
> right?
cf loses track of the currentrow when nesting, you need to track it, ie
<cfloop query="qry1">
<cfset qry1_row=qry1.currentrow>
<cfloop query="qry2">
<cfoutput>#qry1.name[qry1_row]# #qry2.name#</cfoutput>
</cfloop>
</cfloop>
z
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
