- see footer for list info -<
Mark,
To some degree I've found triggers can be unmanageable (although a very
very good tool) - especially when you don't know they are there - it's
caught me out a couple of times in the past, and can be quite annoying.
I would comment your cf pages so that when you've forgotten about them
in 3-6 months, that you can go back and remind yourself that they are
there ;)
Tomo
Mark Smyth wrote:
- 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 -<
___________________________________________________________
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 -<
