>- see footer for list info -< Well I had a similar situation, where I have many table linked to a client. When that client gets deleted, all other data in other tables is also marked as deleted.
I do this with a trigger, but monitoring is the "deleted" column gets changed, and if it is, I updated all the related records in the other tables to be deleted as well. The comments on managability are true, but the same applies to stored procedures, if you use those in your DB. You have to know they are there, and you have to remember to update them if anything in your DB changes. In my code where I use CFQUERY to updates tables that are affected by a trigger, I always put a note to that affect, to remind myself or any other developers that something else happens behind the scenes. Russ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tomo Sent: 07 September 2005 10:04 To: Coldfusion Development Subject: Re: [CF-Dev] Multiple updates & Triggers >- see footer for list info -< NO, I am interested in their input. Adrian Lynch wrote: >>- see footer for list info -< > > Ok, first off, could Russ and Neil please leave! > > Wise man say, Neil + Russ + triggers = many many emails! > > :OD > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Mark Smyth > Sent: 07 September 2005 09:39 > To: 'Coldfusion Development' > Subject: [CF-Dev] Multiple updates & Triggers > > > >>- see footer for list info -< > > OK Guys, > > I've inherited an app which manages suppliers > > Once a supplier is no longer valid, they are deactivated. This > basically means an update which has to occur on around 6 tables at the same time. > > The updates are currently done via 6 cfqueries but the apps using SQL > server, so i'm thinking that using a trigger would make sense. > > Anyone think of anything more appropriate or are triggers the best way? > > Cheers > Mark > > > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go > to http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >>- Hosting provided by www.cfmxhosting.co.uk -< >>- Forum provided by www.fusetalk.com -< >>- DHTML Menus provided by www.APYCOM.com -< >>- Lists hosted by www.Gradwell.com -< >>- CFdeveloper is run by Russ Michaels, feel free to volunteer your >>help -< > > -- > No virus found in this incoming message. > Checked by AVG Anti-Virus. > Version: 7.0.344 / Virus Database: 267.10.18/91 - Release Date: > 06/09/2005 > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go > to http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >>- Hosting provided by www.cfmxhosting.co.uk -< >>- Forum provided by www.fusetalk.com -< >>- DHTML Menus provided by www.APYCOM.com -< >>- Lists hosted by www.Gradwell.com -< >>- CFdeveloper is run by Russ Michaels, feel free to volunteer your >>help -< > > ___________________________________________________________ To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. http://uk.security.yahoo.com _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
