> Oh, one third issue, you'll have to have a trigger for each table. I'm pretty much dealing with a single table. It's roughly 800 records with around 1200 columns.
The table is already populated with basic info on all the systems in question. There's is usually only one person involved with updating their specific record, so there's only one "user" per record to keep up with. The hard part seems to be giving the client the update log in a format that makes sense to them. They're asking to see something like: Bob Smith, owner of "Data Sys One", performed the following updates: 1. Changed SOX compliance date from 11/12/1999 to 2/12/2001 2. Changed System last backup date from 2/23/2007 to 2/26/2007 It gets tough because the two fields in question above might be named "I_secII_8A_soxcomp" and "V_sec37_37b1_sysbak" or something, and they really don't want to see the field names. Any way I do this, it's going to be a butt-load of coding ($$$). ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270410 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
