I need to record field/column level changes to a change log for a financial application. Does anyone have a good model of how to do this?
There are two approaches that I see. Does anyone have comments on these two methods? 1. Hide copies of all modifiable form fields on the form for server side comparison of all columns which have changed. This would be used to write change log rows for all modified columns. 2. Execute a SQL retrieval of the row for column level comparison with the form's fields before writing the UPDATE query. We will be running on SQL server. Any sample code would be a big help. Wally Randall Gaithersburg Maryland FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
