Create an archive table for each table you want to keep audit history on. Add a few fields to the archive table adding things like change made by, date changed, revision number? Reason changed? Everytime a record is updated, update the live record and make an entry to the archive table. stamped with change information. This will allow changes to tracked and reverted if required. A little fudging and you can do some work process stuff. ie submit for approval, save as draft and publish/approve. Eric From: "Jeremy Allen" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: RE: Is this possible w/CF??? Date: Mon, 20 Nov 2000 11:02:37 -0500 It wouldnt, im a goof :-) Jeremy Allen ElliptIQ Inc. -----Original Message----- From: Rif Kiamil [mailto:[EMAIL PROTECTED]] Sent: Monday, November 20, 2000 9:51 AM To: CF-Talk Subject: RE: Is this possible w/CF??? If u where going to uses a Triggers, how would it know the UserID ? >From R -----Original Message----- From: Jeremy Allen [mailto:[EMAIL PROTECTED]] Sent: 20 November 2000 14:26 To: CF-Talk Subject: RE: Is this possible w/CF??? Just to toss a little more to this suggestion. Assuming this is not an Access database, one way to make things a bit more effecient is to use Stored Procedures to perform all of the actual logging. :-) (Triggers:) Then just use CF to figure out how to reconstruct and assemble the interface to view the log table in a easy to understand/administer fashion Jeremy Allen ElliptIQ Inc. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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 _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.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
