You don't have to call the query again. You can just do this: <cfquery dataset="mydsn" name="dset"> select first,last from name </cfquery> <cfoutput query="dset"> ..do something </cfoutput> <cfoutput query="dset"> ..do something else </cfoutput>
On Tue, Jun 8, 2010 at 5:45 PM, Dave Hatz <[email protected]> wrote: > > 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 ag ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:334400 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
