Well, to tell you the truth I am not sure. I have never tried to manipulate the data before. I think in CF 5 there is a way to add rows and change data in a query. not sure if that would work with a session or not.
----- Original Message ----- From: "Troy Simpson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, January 14, 2002 6:02 PM Subject: Re: Copy a Query into a Session Variable (o8i) > Will this allow me to control the structure, like when it will timeout, > add rows to it, manipulate the data, etc? > > Troy > > David Brown wrote: > > > 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 > > > > > ______________________________________________________________________ Get Your Own 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=coldfusionb 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
