> Assuming you've got your DB code abstracted to a central place > (to totally misuse abstract, probably), it should be a snap to add > a secondary insert into the duplicate table whenever an update > occurs.
> Then add a function that loops through those records, and creates > a "diff" for the modified fields. Pretty much seems the way I'm probably going - or at least the way I *understand* how to do it. Some of the other suggestions look cool, but I can wrap my poor aching head around this one.... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270550 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
