get cached query result set

2014-04-03 Thread John M Bliss
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

Re: get cached query result set

2014-04-03 Thread John M Bliss
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

Re: get cached query result set

2014-04-03 Thread Byron Mann
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

Re: get cached query result set

2014-04-03 Thread John M Bliss
=#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