What you've got is close. If you want the variable to persist over time you
will need to use a session, application, or server variable. For these keep
an eye on the <CFLOCK> threads, or check out the documentation.
<cfquery name="myquery" . . .>
select myfield from . . .
</cfquery>
<cflock . . . >
<cfset session.myvar = myquery>
</cflock>
<cflock . . . >
<cfoutput query="session.myvar">
#myfield#
</cfoutput>
</cflock>
Dan
-----Original Message-----
From: Eli Shechter [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 12, 2000 11:33 AM
To: [EMAIL PROTECTED]
Subject: saving queries
Hi
i know there is a way to do this, i just dont know the syntax.
i would like to save a query result into a variable
<cfset var = query.resultset>
can anyone help me with the proper way to do this??
Thanx
-Eli-
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
