How about <cfquery name="session.qryResults" datasource="dsn"> </cfquery>
-----Original Message----- From: Troy Simpson [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 5:55 PM To: CF-Talk Subject: Copy a Query into a Session Variable (o8i) I want to query a database and store the result set in a Session Variable for manipulation. Then Update the database with the changes when the user submits a save request. How do I make a copy of the query result set into a session variable? Is this a copy of qryResults or a pointer to qryResults. <cfset session.results = qryResults> Thanks, Troy -- Troy Simpson | North Carolina State University NCSU Libraries | Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 It is better to be hated for what you are than to be loved for what you are not. -- Andre Gide ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
