Larry, I don't know if this interests you, but I have one case where I use a database trigger (in SQL Server) to log ALL changes to the table.
Basically, an audit table is created that logs all the data changes .. here's the trigger It's quite generic, you just have to change the database name and table name. Here it is nicely formatted and colorized at pastebin... http://cfm.pastebin.com/1iPps9dB Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336422 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
