Re: How do I flush cached queries?

[Pete Ruckelshaus]

The problem is with caching dynamic queries.  If you cache a query that has dynamic statements, it will cache the result set from each dynamic statement that is run.

I'll try Jeff's solution.

Thanks for the help!

Pete
  ----- Original Message -----
  From: Philip Arnold
  To: CF-Talk
  Sent: Friday, October 10, 2003 9:18 AM
  Subject: RE: How do I flush cached queries?

  I thought that DBCOMMECTIONS_FLUSH only flushed the ODBC connectors, not
  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]

---