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 -----Original Message----- From: Eron Cohen [mailto:[EMAIL PROTECTED] Sent: 31 October 2007 13:56 To: CF-Talk Subject: Creating an Audit Trail 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292403 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4