If you want to make sure that you have a copy of the query instead of a pointer, then use:
<cfset session.results = duplicate(qryResults)> It's that easy. ----- Original Message ----- From: Troy Simpson <[EMAIL PROTECTED]> Date: Monday, January 14, 2002 3:55 pm 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 chang es > 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/cf-talk@houseoffusion com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sideb ar=lists > ______________________________________________________________________ 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
