<cfset application.x = y> There ya go. :) That assumes Y is a query. Here is a more fuller, but still a bit pseudo-code, example:
<cfif not structKeyExists(application,"states")> <cfquery name="getStates" datasource="foo"> select id, name from states </cfquery> <cfset application.states = getStates> </cfif> Obviously this could be wrapped up into a CFC. On Wed, Nov 12, 2008 at 4:43 PM, George Lu <[EMAIL PROTECTED]> wrote: > Thank you Raymond. I've tried the first one - it didn't work. I'll try the > second one. > > Would you be able to give me an example how to put cache in the Application > scope? > > Thanks, > George > > 2008/11/13 Raymond Camden <[EMAIL PROTECTED]> >> >> You have two methods: >> >> 1) <cfobjectcache action="clear"> >> >> This clears ALL cached queries on the entire box. >> >> 2) You can rerun the query with a timespan of 0,0,0,0. >> >> Note - the SQL must be the exact same, and that includes white space! >> >> Personally I cache my queries in the Application or Session scope. >> Makes it a lot easier to clear. >> >> On Wed, Nov 12, 2008 at 4:22 PM, George Lu <[EMAIL PROTECTED]> wrote: >> > Hi, >> > >> > I've got a query in a CFC with a cache setting: >> > cachedWithin="#CreateTimeSpan(7,0,0,0)#". I've updated the query but how >> > can >> > I clear or reset the cache so I can see the updated query result now? >> > >> > Thanks, >> > George >> > >> > > >> > >> >> >> >> -- >> >> =========================================================================== >> Raymond Camden, VP of Software Dev, Broadchoice >> >> Email : [EMAIL PROTECTED] >> Blog : www.coldfusionjedi.com >> AOL IM : cfjedimaster >> >> Keep up to date with the community: http://www.coldfusionbloggers.org >> >> > > > > > -- =========================================================================== Raymond Camden, VP of Software Dev, Broadchoice Email : [EMAIL PROTECTED] Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.org --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
