I prefer the more straight forward method...
<!--- this goes in the top of the application.cfm --->
<cfif isDefined("url.uncache")>
<cfset a = 0>
<cfelse>
<cfset a = 3>
</cfif>
<!--- queries go where you want them... --->
<cfquery dataSource="myDB" name="getCust"
cachedwithin="#createTimeSpan(0,a,0,0)#">
select *
from customers
</cfquery>
<!-- then whenever you make an update on the admin
side, just click a link that points to your
homepage... for instance the link could look like
this...
http://localhost/myCustomerApp/index.cfm?uncache=true
whenever you follow a link to your application the
the uncache paramater attached, it will reset all of
your cached queries that you have used the a variable
on. --->
--- Jake <[EMAIL PROTECTED]> wrote:
> I have an application that output some data on the
> front end. I'd like
> to cache some of those queries for a long period,
> since they rarely
> update. But at the same time, I have to be able to
> show updated results
> immediately.
>
> Is there a way to cache a query but then kill the
> cache as soon as
> something is added via the admin tool? Is it a
> simple as simply
> rerunning the front end query on the admin side?
>
> Is there another way to do this?
>
> Jake
>
>
----------------------------------------------------------
> To post, send email to [EMAIL PROTECTED]
> To unsubscribe:
> http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
> To subscribe:
>
> http://www.dfwcfug.org/form_MemberRegistration.cfm
>
>
>
=====
Anthony C. Frey
214-529-1507
[EMAIL PROTECTED]
__________________________________
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail
----------------------------------------------------------
To post, send email to [EMAIL PROTECTED]
To unsubscribe:
http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
http://www.dfwcfug.org/form_MemberRegistration.cfm
