it back then or not. This definitely works in MX. Also, the
"cachewithin" attribute is pretty much a must unless you have a query
you want to keep indefinitely (be nice to your RAM memory, it is your
friend). Another point, this will clear all queries in the cache so it
may be overkill. The previous suggestion about setting the cachewithin
attribute to '0' is a surefire way to kill the cache on just a single
query. S. Isaac (who is lurking on this list daily) has some pretty neat
ways to cache queries within his framework, onTap.
Good luck,
-JSLucido
-----Original Message-----
From: Jeff Lucido [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 8:20 AM
To: CF-Talk
Subject: RE: How do I flush cached queries?
<cfobjectcache action="">
Good luck,
-JSLucido
-----Original Message-----
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 8:03 AM
To: CF-Talk
Subject: How do I flush cached queries?
I have tried using the undocumented <cfset
CFUSION_DBCONNECTIONS_FLUSH()> but it is not flushing query results and
forcing a new query (I want to flush the cached queryies whenever an
administrator updates info in the database). Is there any other way to
flush cached query results? I am using CF5 on Win2K with MS SQL Server
2000.
Thanks
Pete
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
