This may not be the answer you're looking for, but one thing you can do to make this easier on yourself is to set your cachedafter date to an application variable, then set the variable to correspond to the date of your last update. Technically it doesn't "uncache" all the pages at once, but the net effect is the same. -----Original Message----- From: Al Musella, DPM [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 1:42 PM To: CF-Talk Subject: How to uncache a querry? 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? Al Musella, DPM A1webs.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
