>You can use <cfobjectcache action = "" to clear all cached queries
>

I'm not sure that's what he's after. If you use the above, you blow away the
entire cache, instead of just the query or queries that you want to refresh.
You could store the query results in the Application scope (or some shared
scope) and then refresh the key in the scope when necessary with the new
results. Something like:

<cfif I want to update my query>
  <cfset structDelete(Application, "myQuery", "No") />
</cfif>

<cfif NOT structKeyExists(Application, "myQuery")>
  <cfquery name="Application.myQuery" datasource...>
</cfif>

If you're using the Session scope for a personalized query, then just change
Application to Session in the above code.

Regards,
Dave.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to