Nope, all names (query and column) are different between the two queries. -----Original Message----- From: Zac Spitzer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 9:21 AM To: CF-Talk Subject: Re: Nested Query Loops
Jeff D. Chastain wrote: > I am not even making it that far. I am getting an error on <cfloop > query="qry2"> stating that qry2 is not a recordset. If I do a <cfdump > prior to the first loop, qry2 is a recordset with several rows of > data. If I do a <cfdump right before the second loop (i.e. inside the > outer loop), then qry2 is null. For some reason the variable is just > gone. umm is qry2 by anychance a column name in qry1? 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 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