We will need to see more of the code. If the second loop doesn't work then there is probably something in the code that is stopping your action. Once the query has been created, it will persist until it is erased by the code.
-----Original Message----- From: Dave Hatz <daveh...@hatzventures.org> Sent: Tuesday, June 08, 2010 5:45 PM To: cf-talk <cf-talk@houseoffusion.com> Subject: How to loop over a dataset twice. I am trying to loop over a dataset twice. I am trying using CFLOOP but the 2nd CFLOOP will not process. <cfquery dataset="mydsn" name="dset"> select first,last from name </cfquery> //loop through DataSet 1st time <cfloop query="dset"> .... </cfloop> //Now I want to loop through the DataSet a 2nd time <cfloop query="dset"> ..... </cfloop> How do I get the 2nd cfloop to loop over the DataSet without calling the query again? Thanks, Dave ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334398 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm