A client has requested a "change log" on their database. Basically, it's a SQL server database with several hundred fields used for updating information on specific computer/data systems within a group of businesses. What they're asking for is when client logs in and updates their info, they want to keep a summary of what's been changed in addition to updating the database itself.
They do *not* want a full copy of the complete record each time a change is made (which is what I would have done). They just want to see something that says "On March 3, 2007, Bob changed field 64 on page 11 of the form". Almost the only thing I can think of is to do a compare on every single data field in the database on each submit to see what's changed, and then add that to a log. Considering the number of fields - ack! I shouldn't complain too much, as they don't care how much it costs and pay quickly - but, is there a more efficient way of doing this? Ideas? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270220 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
