[thelist] CF: Clearing a cached query?

Raymond Camden jedimaster at macromedia.com
Tue Oct 15 10:42:01 CDT 2002


FYI, a bit off topic, but you can remove ALL queries from the cache by
doing:

<cfobjectcache action="clear">

Another solution is to NOT use query caching, but to store the query in
the application/server/session scope. Then you can nuke it by simply
overwriting it, or using structDelete to remove it.

In general, my #1 recommendation - use a CFC where the timeout is a
parameter. Default to having caching enabled.

=======================================================================
Raymond Camden, ColdFusion Jedi Master for Hire

Email    : jedimaster at macromedia.com
WWW      : www.camdenfamily.com/morpheus
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda

> -----Original Message-----
> From: thelist-admin at lists.evolt.org
> [mailto:thelist-admin at lists.evolt.org] On Behalf Of rudy
> Sent: Tuesday, October 15, 2002 11:28 AM
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] CF: Clearing a cached query?
>
>
> > unless I'm reusing the query (which is another avoidable problem)
>
> ???
>
> morgan, have a care, i'm an old man and my heart can't take that kinda
> shock
>
> i am certain you meant something other than what it sounds like
>
> reusing a query is not a problem
>
> it is something to aspire to, not avoid
>
>





More information about the thelist mailing list