> Is there a simpler way to detect the change in order to fire the > deletion of the cached pages?
For a small system you're already doing it the way I would approach it. I would have the "deletion" routine only delete what needs to be removed given the change detected to minimize the work around that process (if you aren't already). Another option would be to use a trigger (on update or delete) which could update a logging table which a scheduled task can check against for any changes. If your SQL server has access to the web server you could also have a trigger fire a process to delete the files as needed (or call a URL so ColdFusion can do it for you). -Justin Scott ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349268 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
