Thanks for clarification... Did not find any posts.. matching my request.. so posted..
just a FYI.. nested loops over queries worked fine for me.. in MX6.1.. infact I still have 2 systems without the 6.1 updater applied.. on which I tested the code.. however I think this point has been discussed 101X on this list.. so there goes 102 times.. :-) -- Regards, Pascal Peters wrote: > This has always been like this (and must have been discussed a 100x on > this list). When you have nested loops over queries (it doesn't matter > if you are using cfoutput or cfloop), coldfusion looses the reference to > the first query when looping the second. This means that you can't drop > the prefix (which you shouldn't in the first place) and that > q1.currentRow will always return 1 (and q1.column will always return the > value from the first record. You have already found the solution for > that problem: set the value to a variable before the second loop. > > If you have a lot of fields from the first query to access in the second > loop, just save the currentRow in a variable and use array notation for > the first query. > > <cfloop query="q1"> > <cfset i = q1.currentRow> > <cfloop query="q2"> > <cfif q2.c1 IS q1.c1[i]> > do something > </cfif> > </cfloop> > </cfloop> > > Pascal > > >>-----Original Message----- >>From: Umer Farooq [mailto:[EMAIL PROTECTED] >>Sent: 10 December 2004 02:54 >>To: CF-Talk >>Subject: odd.. cfoutput group and cfloop over query >> >>Hi, >> >> I'm getting this odd.. problem.. when doing.. >> >> <cfouput query="QUERYONE" group="SOMECOLUMN"> >> <cfloop query="QUERYTWO"> >> <cfif QUERYONE.XID eq QUERYTWO.YID> >> SOMETHING >> </cfif> >> </cfloop> >> </cfoutput> >> >> in the loop QUERYONE.XID will keep the first row value. >> >> if I remove the prefix from XID.. it gives me an error saying its >>not defined. Which is odd by itself. >> >> I can get away from the error by setting a variable.. before the >>loop and then compare on it.. >> >> Any thoughts on this.. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187348 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
