Also, assuming I want to use some of the cfquery enhancements, is this how I
would name the cached query and define how long it lasts? Having to manually
clear the cache isn't an option, it needs to clear after a set amount of
time.
<cfquery name="getartists" datasource="artists_db"
cachename="artist_db_cache" cachedwithin="#CreateTimeSpan(0,0,0,15)#">
SELECT *
FROM Artists
</cfquery>
My goals
All I really want to do is:
-run a query, then cache it (and name it as well)
-define how long the query lasts so that it expires automatically
-be able to run queries against the cached query
-be able to get data about the cache (if it exists, when it expires, etc)
ie
<CFIF isdefined(cachedquery4562DDFD)>
--
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 !!
