Well, just a quick solution off the top of my head.... You need a transaction log table. Something like:
id - index action - what action was taken, update/delete/insert user - what user performed the action tstamp - when they did it table - what table was affected row - what row (id) was changed value - what the original value was newvalue - what the changed value is (for action is update) Then you need some code to pull all this data together. I would suggesting using a customtag for the actual logging function. Or add a trigger for UPDATE/INSERT/DELETE on the tables you want to monitor. Regards, Jon On Mon, 14 Feb 2005 19:47:58 -0600, Jeff Chastain <[EMAIL PROTECTED]> wrote: > I am trying to implement history tracking functionality for a system. For > example, I need to know that John Doe changed object x on date y. Even > better would be being able to take that a step further and see that John Doe > changed the data in table a, column b from 'abc' to 'xyz' and therefore, I > could undo this transaction. To make this one step more complicated, the > objects that I am tracking history for are organized in a hierarchical > fashion and I would like to be able to see the history for one object > including any changes made to any child objects. > > I want to implement this as generically as possible so that as this system > grows, the history tracking won't break. Even better, I might be able to > reuse it in another app. > > So, does anybody know of any examples or resources that I could look at for > some ideas? I am not even sure what to Google for this one. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194649 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
