I havent checked up on this so I might be wrong.... you could use CFLOG to produce a log file of all the actions.. These can then be parsed however you want, I am not sure if its more/less efficient than db but it could serve a purpose
Otherwise as people have mentioned... create either a custom tag or CFC with the parameters that you want e.g. user, old value, new value, action to add them to your db Regards Mark Drew On Sun, 31 Oct 2004 21:53:10 -0500, Aaron Rouse <[EMAIL PROTECTED]> wrote: > I inherited a project that does this via CF and inserts into a table. > It basically calls a custom tag anytime a insert/update/delete is done > via the web site. You could do it in the DB via triggers or I assume > it could be done in PGSQL. > > On Sat, 30 Oct 2004 20:04:40 -0200, Web Specialist > > > <[EMAIL PROTECTED]> wrote: > > Hi > > > > it's possible to log all users actions in a DB? I'm using PostgreSQL. > > Looks like: > > > > User / Action / Datetime / Original Value / Value Now / > > > > I should use DB tools or CF could help me? > > > > Thanx in advance > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Protect your mail server with built in anti-virus protection. It's not only good for you, it's good for everybody. http://www.houseoffusion.com/banners/view.cfm?bannerid=39 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183050 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