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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.