Thanks, I was hoping that Macromedia had a simple function I could use like Struc tCopy for structures or ArrayCopy for arrays. I really did not want to manipulate a query structure any more than I had too. It keep the code simple.
I guess a query variable is different than the other data structures. Thanks, Troy David Brown wrote: > You could try this: > <body> > <H3>QueryAddRow Example</H3> > > <!--- start by making a query ---> > <cfquery name = "GetCourses" datasource = "cfsnippets"> > SELECT Course_ID, Course_Num, Descript > FROM Courses > </cfquery> > > <P>The Query "GetCourses" has <cfoutput>#GetCourses.RecordCount# > </cfoutput> rows. > > <cfset CountVar = 0> > <CFLOOP CONDITION = "CountVar LT 15"> > <cfset temp = QueryAddRow(GetCourses)> > <cfset CountVar = CountVar + 1> > <cfset Temp = QuerySetCell(GetCourses, "Course_ID", CountVar)> > <cfset CountVar = CountVar + 1> > <cfset Temp = QuerySetCell(GetCourses, "Course_Num", 100*CountVar)> > <cfset CountVar = CountVar + 1> > <cfset Temp = QuerySetCell(GetCourses, "Descript", > "Description of variable #Countvar#")> > </CFLOOP> > .. > This is from help in CF 5.0 it is a way to add rows and cell data to a > query. you could try that with a session. > ----- Original Message ----- > From: "Troy Simpson" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, January 14, 2002 6:04 PM > Subject: Re: Copy a Query into a Session Variable (o8i) > > > David, > > > > Thanks. > > This may be what I need. > > But if I wanted to copy an existing query result set, how would I do that > > ? > > > > 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 chang es > > > when the user submits a save request. > > > > > > How do I make a copy of the query result set into a session variabl e? > > > > > > 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
