Close, but try this. (It assumes there is only one record returned from the query.) You can treat the query, and session scope, as structures. The query is also treated as an array to get the first element.
<cfloop index="thisOne" list="#areaJobInfo.columnList#"> <cfset session[thisOne] = areaJobInfo[thisOne][1]> </cfloop> I'm not sure of the array notiation for the right side of the set statement. You should double-check that. I don't have a server handy to test this and I always forget the exact syntax. M!ke -----Original Message----- From: Mark Fuqua [mailto:[EMAIL PROTECTED] Sent: Monday, September 19, 2005 7:10 PM To: CF-Talk Subject: RE: looping over the fields of a one record query I am a little green, do you mean like so... <cfloop index="listelement" list="#areaJobInfo.columnList#"> <cfset session.#areaJobInfo.columnList# = #listElement#> </cfloop> That doesn't seem like it would work. What am I missing. Thanks, Mark ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218654 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54