> I make extensive use of cached queries on 1 of my websites, that uses
> read-only data that gets updated once a week..
>
> the problem is that when I update that database, I want to clear
> the cache
> so the new data is used.. sometimes the cached querry presents a record
> that is no longer available, and when you click to get the details - the
> record is no longer there, so it generates an error.
>
> So - how do you clear the cache? Hopefully with cfcode without having to
> restart the CF server?
Fastest way is to rerun the query with a cache time of
CreateTimeSpan(0,0,0,0) - this will clear the query and regenerate it "now"
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
