the cached queries
Anyways, the way I do it is to put a CreateTimeSpan(0,0,0,0) in the
CACHEDWITHIN, that tells CF to get the latest data
If you're using CACHEDWITHIN, then I'd suggest putting the time span
into a variable, and then when a certain URL condition is met, then set
the time span to 0 - thus flushing all queries
-----Original Message-----
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 9: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]
