[thelist] CF: Clearing a cached query?

[Raymond Camden]

>
> Here's what I would suggest--create a routine to do the query
> and push the
> data to disk in a manner that can be quickly read by CF.
> Writing out CF code
> to be cfincluded later would be my suggestion.  The file
> should be nothing
> more than a bunch of cfsets, such as:
>
> <cfset nav = ArrayNew(1)>
> <cfset nav[1] = StructNew()>
> <cfset nav[1].title = "title1">
> <cfset nav[1].href = "href1">
> ...
> etc
> ...
>
> Then, cfinclude this file within application.cfm.  Any time that the
> navigation changes, rerun the code that generates the file.
> It'll be real
> quick on the front end.

By the same token, I'd suggest using the application scope as well,
although it won't "stick" as long as using the file system.

-ray