I have not, sorry. This sounds like this could turn into a resource intensive script (lots of nested loops and queries). Is there anyway you can consolidate the queries (recursive sql, self joins, cfoutput grouping)?
Eric -----Original Message----- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 4:43 PM To: CF-Talk Subject: query of query, nested loops... Hello all, Here is my process: I query the database in query1. I query query1, call it query2. Loop through query2. While in the query2 loop, I query query1 again, call it query3. Loop through query3. While in the query3 loop, I query query1 again, call it query4. Are you seeing the pattern? Rather than paste my code (lots), I'll ask the blanket question: Has anybody heard of problems with cf5's query of query and nested loops? What happens is in the third level deep of these nested loops, the query of query acts as if it's ignoring my where clause and pulls more records than it's supposed to. Anybody hear of this before? Thanks... Ryan Ryan J. Pieszak Applications Engineer Ziphany, LLC. (716) 510-0379 www.ziphany.com ______________________________________________________________________ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
