On each loop, whatever values you want to use in your inner loops need to be set to a local variable in the loop. In fact, been burned so many times now I just dont bother using the loop count and alwasy set the variables I need straight after my cfloop
ie <cfloop query="qSomething"> <cfset loop1Col1 = qSomething.MultiplyBy20 > <cfset loop1Col2 = qSomething.MultiplyBy30 > <cfloop from="1" to="100" index="tIndex"> <cfset output1 = loop1Col1 * tIndex> <cfset output2 = loop1Col2 * tIndex> <cfoutput>#tIndex# - #output1# - #output2#</cfoutput> </cfloop> </cfloop> Trying to access it as... <cfset output1 = qSomething.MultiplyBy20 * tIndex> Doesn't work (well, i didn't test the code but I hope you get my drift) There is a tech support somewhere about this on the MM site but I can't find much (no patience with it) any more and prefer looking elsewhere This could be described as a FEATURE of cold fusion....hehehehe -----Original Message----- From: Tony Schreiber [mailto:[EMAIL PROTECTED] Sent: 27 March 2003 17:04 To: CF-Talk Subject: Nested Query Loop Bug/Issue I don't know if any of you have run into this before or if it's even been mentioned (couldn't find it at mm technotes either), but I've run into a situation where the values of an outer loop referred to in an inner loop are not what you expect. I was burned on this recently and remember vaguely it happening to me before. I've written some demonstration code to illustrate: http://www.simplemessageboard.com/loopbug.cfm The solution as shown in the code is to set a local variable BEFORE you begin the inner loop to hold the value of the outer loop you want to refer to within the inner loop. Anyone had this happen? Or is this expected behavior that I can't see? BTW, this is CF5, I don't know about MX. Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.is300.net The Enthusiast's Home of the Lexus IS300 since 1999 http://www.simplemessageboard.com Free Forum Software for Cold Fusion ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4