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:358301
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
