Phil, In one application where I have done this, I do it in a somewhat "ganky" way. Basically I have an UserActionTracker and what it does is everytime I submit a FORM for DB committing, I also send the FORM object to the Tracker component:
UserActionTracker.TrackAction( SESSION.User, FORM, [...] ) The tracker then takes the FORM data and converts it to an XML structured string and stores that to the DB. So basically this takes Snap Shots of the item data, but does not track individual changes. You are gonna end up storing a lot of data, which is why I purge stored form data after 3 weeks. Certainly NOT the best solution, but the only one I have tried to date. ....................... Ben Nadel Web Developer Nylon Technology 350 7th Avenue Floor 10 New York, NY 10001 212.691.1134 212.691.3477 fax www.nylontechnology.com "You know, like nunchuck skills, bowhunting skills, computer hacking skills... Girls only want boyfriends who have great skills." - Napoleon Dynamite -----Original Message----- From: Phill B [mailto:[EMAIL PROTECTED] Sent: Thursday, May 11, 2006 12:42 PM To: CF-Talk Subject: Re: Anyone done this before? That would have been a better way of putting it. Yes We want to track the changes made in the database. We would like to keep it indefinitely. On 5/11/06, Ben Nadel <[EMAIL PROTECTED]> wrote: > By auditing, do you mean tracking changes? If so, how long do you need > to keep the old data for? > > ....................... > Ben Nadel > Web Developer > Nylon Technology > 350 7th Avenue > Floor 10 > New York, NY 10001 > 212.691.1134 > 212.691.3477 fax > www.nylontechnology.com > > "You know, like nunchuck skills, bowhunting skills, computer hacking > skills... Girls only want boyfriends who have great skills." > - Napoleon Dynamite > -----Original Message----- > From: Phill B [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 11, 2006 11:12 AM > To: CF-Talk > Subject: Anyone done this before? > > We want to start auditing the database changes made in our home grown > CMS app. Anyone on here done this or have suggestions on where to > start with some thing like this? > > -- > Phil > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240236 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
