You could try this where you set up global variables:
<cfif IsDefined("ClearQueryCache")>
<cfset REQUEST.QueryCacheTime = 0>
<cfelse>
<cfset REQUEST.QueryCacheTime = 30>
</cfif>
Use REQUEST.QueryCacheTime to set the cache on your queries. You could
then
clear the cache on a particular page by adding ClearQueryCache=1 in
the URL.
Stuart Miller
Rocom New Media
+44 (0)1937 847492
http://www.dxtec.net
http://www.rocom.co.uk
-----Original Message-----
From: Tim Stadinski [mailto:[EMAIL PROTECTED]]
Sent: 18 January 2002 16:44
To: CF-Talk
Subject: RE: Un cache all queries or some queries
is there a way to specifiy which query to uncache? this seems to work
for
all queries, but it would be nice to make this work for only a
specified
query. any ideas?
Thanks
Timothy Stadinski
Senior Software Engineer
Afternic.com
[EMAIL PROTECTED]
-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 18, 2002 11:23 AM
To: CF-Talk
Subject: RE: Un cache all queries or some queries
> How could I remove some or all cached queries without
> restarting the CF Server.
There are two ways you can do this. One is to use the CFOBJECTCACHE
tag:
<cfobjectcache action="clear">
This will clear all cached queries from memory. Another is to specify a
timespan of zero in a specific query's CACHEDWITHIN attribute:
<cfquery ... cachedwithin="#CreateTimeSpan(0,0,0,0)#">
.
</cfquery>
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
