I think Ian's may be the way to go. I am using cachedwithin as the data changes frequently so we cache it for 6 hours. I don't think cachedafter will work.
-----Original Message----- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 10, 2005 4:31 PM To: CF-Talk Subject: Re: Cached query - Any way to tell when it was cached? > Is there a way, possibly as easy as an undocumented query > variable > (query_name.CachedSince - one can dream no?), to return > the timestamp of > when a query was last cached? Was looking for an easy way > to have a "This > report last generated on: X" display an a page with a > large recordset that > we currently cache. <cfparam name="application.queryname.cachedafter" type="date" default="#now()#"> <cfquery name="queryname" cachedafter="#application.queryname.cachedafter#"> .....</cfquery> <cfoutput>report last generated on #application.queryname.cachedafter#</cfoutput> s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206274 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
