Jamie,
You could set a variable for the cachetime in Application.cfm or on the page
itself use that in query. Then use a flag variable passed along URL to
indicate whether cached query needs to be cleared. If flag exists, then
change cachetime to zero.
Here's an example.
<-- set in app.cfm -->
<cfset Variables.cachetimelimit=CreateTimeSpan(0,0,30,0)>
<-- page with query>
<cfif IsDefined("URL.modcache")>
<cfset Variables.cachetimelimit=CreateTimeSpan(0,0,0,0)>
</cfif>
<cfquery datasource="#MetaDataSource#" name="MetaTable"
cachedwithin="#Variables.cachetimelimit#">
</cfquery>
Chris
------------------------------------------------------------------
Chris Lomvardias
[EMAIL PROTECTED]
Syscom, Inc.
400 E. Pratt Street, Suite 300
Baltimore, MD 21202
(410)539-3737 x1722 voice
(410)539-7302 fax
[EMAIL PROTECTED] (pager via email)
http://www.syscom.com/
------------------------------------------------------------------
-----Original Message-----
From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 12:03 PM
To: CF-Talk
Subject: Best way to clear Cached Queries?
What's the best way to clear out a cached query, so that your
production site will use the most current database information? I want
to retain my long cache spans on a production box, but I want to be
able to "update" or "refresh" the queries at will.
Here is my current process:
1. Break the connection (give the datasource a faulty path/name) in
the administrator.
2. Hit the template in a browser.
3. Repair the broken connection in the CF administrator.
4. Hit the page again. The query is updated/re-cached.
I don't like this method, because it is awkward, and it momentarily
affects the production site. Is there a better way?
Thanks,
Jamie
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
