[thelist] CF: Clearing a cached query?

Raymond Camden jedimaster at macromedia.com
Tue Oct 15 12:51:01 CDT 2002

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


More information about the thelist mailing list