You have two methods:

1) <cfobjectcache action="clear">

This clears ALL cached queries on the entire box.

2) You can rerun the query with a timespan of 0,0,0,0.

Note - the SQL must be the exact same, and that includes white space!

Personally I cache my queries in the Application or Session scope.
Makes it a lot easier to clear.

On Wed, Nov 12, 2008 at 4:22 PM, George Lu <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I've got a query in a CFC with a cache setting:
> cachedWithin="#CreateTimeSpan(7,0,0,0)#". I've updated the query but how can
> I clear or reset the cache so I can see the updated query result now?
>
> Thanks,
> George
>
> >
>



-- 
===========================================================================
Raymond Camden, VP of Software Dev, Broadchoice

Email    : [EMAIL PROTECTED]
Blog      : www.coldfusionjedi.com
AOL IM : cfjedimaster

Keep up to date with the community: http://www.coldfusionbloggers.org

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to