I usually set the outer query variable to a locally scoped variable inside the outer loop, and that removes the problem. Weird thing is, CF only seems to get confused sometimes, even if there are shared fieldnames...sometimes it works just fine. I usually follow the set local variables practice as a matter of course, and then I don't have to worry about it.
-Kev -----Original Message----- From: Ryan Emerle [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 11:55 AM To: CF-Talk Subject: RE: cfoutput + cfloop: bug or Did you try this? <cfloop query="query1"> <cfoutput>#query1.whatever#</cfoutput> <cfloop query="query2"> <cfoutput>#query2.whatever# #query1.whatever#</cfoutput> </cfloop> </cfloop> I have found when you try to mix queries like that, CF has a bit of a problem, especially if query1 and query2 share fieldnames (even if you 'scope' the queries). A work around would be something like this: <cfloop query="query1"> <!--- Query1 'scope' ---> <cfoutput>#query1.whatever#</cfoutput> <!--- Save in Variable scope ---> <cfset q1whatever=query1.whatever> <cfloop query="query2"> <cfoutput>#query2.whatever# #q1whatever#</cfoutput> </cfloop> </cfloop> I've had to do perform similar workarounds in the past for these goofy situations. I am also of the school that says output and loop iteration should be separate, i rarely use cfouput to iterate through loops. HTH -- Ryan Emerle -----Original Message----- From: Peter Mayer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 9:26 AM To: CF-Talk Subject: cfoutput + cfloop: bug or Hello! I have two queries - the output of the first one is handled by a cfoutput tag, the second one is handled by a cfloop (nested construction): <cfoutput query="query1"> bla bla #query1.name#: <cfloop query="query2> #query2.surname# (event: #query1.eventtitle#)<br> </cfloop> </cfoutput> Now I have the result that query1.eventtitle always returns the first row of query1, it's not looping as desired. my workaround: <cfoutput query="query1"> bla bla #query1.name#: <cfset a_str_title = query1.eventtitle> <cfloop query="query2> #query2.surname# (event: #a_str_title#)<br> </cfloop> </cfoutput> This works as expected. We are on CF 5 (MX in the future time) Best regards, Peter ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
