Sweet! Thanks!
https://wikidocs.adobe.com/wiki/display/coldfusionen/CacheGet
On Thu, Apr 3, 2014 at 11:16 PM, Byron Mann <byronos...@gmail.com> wrote:
>
> Believe, in your scenario, each query version could have a unique cacheID,
> so, cacheID="idFeb2013", cacheID ="idJan2013", ...
>
> To retrieve from cache...
>
> Jan2013=cacheGet("idJan20013");
> Feb2013=cacheGet("idFeb2010");...
>
> Byron Mann
> Lead Engineer & Architect
> HostMySite.com
> On Apr 3, 2014 11:56 AM, "John M Bliss" <bliss.j...@gmail.com> wrote:
>
> >
> > If I cache a query with:
> >
> > cfquery name="recordset" result="thisResult"
> > datasource="#application.datasource#"
> > cachedafter="#CreateDateTime(Year(Now()), Month(Now()), Day(Now()), 5, 0,
> > 0)#" cacheID="mycacheID"
> >
> > ...is there then a way to use "mycacheID" to programmatically get cached
> > query result set without actually re-running that same cfquery?
> >
> > (I have a situation where I have a bunch of cached versions of a report
> for
> > Jan 2013, Feb 2013, etc, and I'm tasked with fetching those reports from
> > the cache and aggregating them into one multi-month report.)
> >
> > --
> > John Bliss - http://www.linkedin.com/in/jbliss
> >
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358302
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
