query caching

[Kiriran]

hi
if i do <cfcache action="cache"> and have a query on this page, is it cached? or do i need to do <cfquery cachedwithin> ?

thanks
k

[MikerRoo]

First, you need to set the "Maximum number of cached queries" to a sufficient
number, greater than zero, in the CF administrator.

<cfcache action="cache"> caches coldfusion's html output it does not cache
queries.

If you use the cachedwithin attribute of CFquery, it will use cached versions
of that query when possible.
See the bottom of
[url]http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/[/url]
wwhelp.htm?context=ColdFusion_Documentation&file=0 0001128.htm for more info.

Regards,
-- MikeR