At 11:23 AM 4/13/00 -0400, you wrote:
>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
One problem I worry about with this: Session variables are frequently
stored in the Registry on NT machines, yes? So if you had a very large
query, or quite a few users, you are potentially packing a lot of info into
the registry. Perhaps unwise.
Judah
------------------------------------------------------------------------------
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.