I do something similar, but I have date_added and date_removed columns (each with a corresponding user column), so I know that if date_removed IS NULL then I have the latest version of the record. It provides full auditing in that we know when a record was added, when it was removed and by whom.
On Tue, Apr 8, 2008 at 2:38 AM, Jim Davis wrote: > > I've done this before using the same table. > > Basically I added two new columns: EditDate (the date of the change) and > EditUser (the user ID of the one making the change). -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302919 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
