A trigger is the anawer, compare the values of INSERTED and DELETED
Paul Hastings wrote:
>
> > 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?
>
> isn't the sql server trans logs enough or that? if not then write triggers
> on to
> handle this.
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.342 / Virus Database: 189 - Release Date: 3/14/2002
>
>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
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
