Yes. You can save the query to SESSION scope.
<cfif NOT IsDefined("SESSION.QueryName")>
<cflock name="#SESSION.SessionID#" timeout="30">
<cfquery name="SESSION.QueryName" datasource="#dsn#">
SQL STUFF
</cfquery>
</cflock>
</cfif>
HTH!
Sharon
At 10:22 AM 4/13/2000 -0400, Duane Boudreau wrote:
>Hi All,
>
>Is it possible to cache a query only for a particular user for only the
>length of his or her session?
>
>I have a query that generates a roles & privileges packet that applies only
>to the current session and user. When the session expires so does the cached
>query.
>
>What the memory load differences vs. storing a session variable with a WDDX
>packet in it?
>
>TIA,
>Duane
>Director, Web Technologies
>Ektron, Inc.
>http://www.ektron.com
>5 Northern Blvd, Suite 6
>Amherst, NH 03031
>Tel: 603-594-0249
>Fax: 603-594-0258
>
>------------------------------------------------------------------------------
>Archives: http://www.eGroups.com/list/cf-talk
>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.eGroups.com/list/cf-talk
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.
