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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
