>- 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 -<
