Thanks everyone for your comments so far. The current app doesn't have any standard framework, eventually it will probably be rewritten with one. For now I just am taking care of the existing code. Currently when the page loads, the values from the database are put into a variable and then when the page is saved a new list is created and then compared to the first list for changes. Changes are logged in a table with the user's id. It is klunky. I think I will see if we can arrange for the database/trigger route instead.
>If you're using anything like the ColdSpring framework then you can apply >this stuff using AOP. I've only recently started working with this concept >but it really is a fantastic one. > >Failing that then I would defiantly recommend building a LoggingService CFC >which handles all the logging for the application, it allows you to keep the >logging methods consistent across the application. The logging class I've >been working on is based on the concept of being able to log to both file >and database, with different log levels, such as info, warning, error, >critical, debug etc. > >Without knowing a little about how your current solution is built its hard >to advise really, how does the current one work? Do you perhaps have a code >sample? > >Hope that helps, > >Rob > >I have a multiuser CSR application that has some audit functionality to >track certain changes to customer records (for instance change of first name >or last name, who changed it and what was it before?). It already logs >these changes, but I think it could be more efficient. I was wondering if >anyone could comment on how they would go about doing this. Right now, it >is strictly code-based. The database is SQL Server 2000 and the server is >ColdFusion 8. > >Thank you ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292408 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
