...or am I going to have to do something like this: - when query is cached, store thisResult.sql somewhere (2013-1.sql on disk) - when query result set is needed, call <cfquery name="recordset" datasource="#application.datasource#">#contents_of_2013-1.sql#</cfquery>
On Thu, Apr 3, 2014 at 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 > -- 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:358300 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm