I like that idea! Nice and simple!

So could you hit that link via CFLOCATION? If so, then I can just do a redirect on submit of my admin form(s), process the kill cache logic, then do another CFLOCATION back to the admin area.

Thoughts?

Anthony Frey wrote:

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






----------------------------------------------------------
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





Reply via email to