Options are always appreciated!
Thanks again.
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 11, 2005 10:03 AM
To: CF-Talk
Subject: RE: Cached query - Any way to tell when it was cached?
I don't blame you. :) I'm just a big fan of opt
D]
> 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
&
> yeah, it's a pity cf doesn't have a built in 'cachedsince'
> value on
> returned queres. CF7 has gotten part of the way there with
> the new
> queryname.Cached value returning true/false but just need
> that last
> little bit..
> jb.
Iirc even before that you could reference cfquery.executionTi
ED]> wrote:
> 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 - An
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 I
> 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:
ubject: 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 &
> How about adding:
> getdate() AS cachedSince
> to the list of columns in the query. getdate() is a SQL
> Server function but most dbs should have an equivalent
> function.
good point...
sql server getdate()
access now()
oracle current_date()
s. isaac dealey 954.522.6080
new epoch : isn't
> 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 recordse
How about adding:
getdate() AS cachedSince
to the list of columns in the query. getdate() is a SQL Server function but
most dbs should have an equivalent function.
Ian
~|
Discover CFTicket - The leading ColdFusion Help Desk an
10 matches
Mail list logo