[thelist] CF: Clearing a cached query?

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


> > Your tests are incorrect - and I should have been more clear.
> >
> > If you run 2 queries with different white space, where the
> first query
> > has a time out of X minutes and the second query has a timeout of 0
> > minutes, you WILL see that the second query is not cached,
> ie, the debug
> > out does NOT show it being cached, however if you rerun the
> first query
> > AND it's within X minutes, it will still show the cached
> data. To prove
> > this, you need to update your tests. Run the first query, run the
> > modified second query with a 0 length timeout, then return
> the first and
> > verify that it is marked cached.
> >
>
> ah, i see what you are saying.
> i must say that seems silly, though.
> if whitespace is insignificant in SQL, why does CF care?

I agree. It's a "issue" in my book. :>

I'll add an enhancement request for:

	Make query caching ignore white space. At the LEAST we can make
it ignore leading/trading white space.
	Make it simpler to remove query caches.

(Please note - when I say I'll add an enhancement request, it just means
I'll add it to our internal bug tracker. It doesn't mean it will get
implemented. I'm a very small cog at Macromedia, and in a few months I
won't even be that, so don't count on it being done. :)

=======================================================================
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





More information about the thelist mailing list