Hi Alan, Well, I'm not worried about expiring the cache manually. Actually, I want to achieve the opposite.
I want to run a query and cache it for a set period of time. ex. 3 minutes. As I mentioned previously, I found the 'CacheCreate' function explanation http://www.openbluedragon.org/docs/index.cfm?function=cachecreate But it doesn't say how to apply this to a query. Is a query 'CFDATA'? It's not very clear. I don't even see how this can be used for a query. Is this how I would use the cache create function? <cfquery name="test" datasource="cfartgallery"> SELECT * FROM Artists </cfquery> <cfset CacheCreate( "querycache", "#cfartgallery#", 3 minutes )> <!--- it's not clear how to define how long the cache is supposed to last ---> And then if I want to query that cached query would I do this <cfquery name="cachedquery" datasource="#querycache#"> SELECT * FROM Artists </cfquery> -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon mailing list - http://groups.google.com/group/openbd?hl=en !! save a network - please trim replies before posting !!
