thanks, although would that not just overwrite the data in row 1?
><cfquery > name="GetParks" datasource="cfdocexamples" > cachedwithin="#CreateTimeSpan(0, 6, 0, 0)#"> > SELECT PARKNAME, REGION, STATE > FROM Parks > Where REGION = 'Southeast Region' > ORDER BY ParkName, State > </cfquery> > ><cfset temp = querysetcell(GetParks, "PARKNAME", " ", 1)> ><cfset temp = querysetcell(GetParks, "REGION", " ", 1)> ><cfset temp = querysetcell(GetParks, "STATE", " ", 1)> >>thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:335909 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm