We host websites using a content management system we developed in CF8 and would like to detect whenever a user changes anything in their website template. If changed, code would run that would delete their cached pages.
Changes are recorded in a SQL Server db. There are 12 different tables that are used. Here's what we've come up with. 1. Insert a date time stamp when a change is made, and then query each table to see if there are any changes. 2. Delete the cached pages any time there is an insert or update. (there are a ton of these). Is there a simpler way to detect the change in order to fire the deletion of the cached pages? Thanks in advance. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:349267 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm