I don't blame you. :) I'm just a big fan of options, so I figured I'd give the FYI just for general purpose, so you can stash it away in the back of your brain in case you have some other similar situation later (presumably one that doesn't have a simpler solution, for example: if you end up working on a project where the manager requires that all caching be performed manually).
> Yeah, for simplicities sake I'll go with the other one, > heh. > Thanks for the help guys. > -----Original Message----- > From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 10, 2005 7:19 PM > To: CF-Talk > Subject: RE: Cached query - Any way to tell when it was > cached? >> 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. > sure it will -- although the alternative is simpler... > but fyi here's the way to accomplish 6 hr caching with > cachedafter: > <cfparam name="application.queryname.cachedafter" > type="date" > default="#now()#"> > <cfif > abs(datediff("h",application.queryname.cachedafter,now())) > gte > 6> > <cfset application.queryname.cachedafter = now()> > </cfif> > <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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206360 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
