Thank you Raymond. I've tried the first one - it didn't work. I'll try the
second one.

Would you be able to give me an example how to put cache in the Application
scope?

Thanks,
George

2008/11/13 Raymond Camden <[EMAIL PROTECTED]>

>
> 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 [email protected]
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