Cached queries don't need to be "stored" anywhere. When you specify a query
to be cached, ColdFusion stores the results in a special area. When you make
the same SQL request to the same datasource within the given timespan,
ColdFusion retrieves the results from this hidden area. There's no way to
access the cache directly.
Storing the results in the Application scope would allow you to retrieve the
data without even calling a new CFQUERY, but can quickly bloat the
application storage. Caching the results, and calling a new CFQuery, would
be preferable.
Just specify the time span to cache within, and you're set :).
hope this helps!
Norman
-----Original Message-----
From: Paul Smith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 14, 2001 4:15 PM
To: CF-Talk
Subject: Re: Cached Query
If it's cached you don't need to put it in Application scope
(and probably don't want to).
I put mine in Request scope, but I'm not sure I need to.
best, paul
At 02:52 PM 6/14/01 -0400, you wrote:
>Is a cached query always within the application scope? Or do I need to add
>"Application." before the query name?
>
>Thanks
>Duncan Hays
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
