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 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
