Exactly...personally I avoid them and I go out of my way to not use them - but you are correct, if you find a need - go for it..
-----Original Message----- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: 18 April 2005 15:56 To: CF-Talk Subject: RE: SQL Triggers (was Re: Last ID inserted) > -----Original Message----- > From: Robertson-Ravo, Neil (RX) [mailto:Neil.Robertson- > [EMAIL PROTECTED] > Sent: Monday, April 18, 2005 8:54 AM > To: CF-Talk > Subject: RE: SQL Triggers (was Re: Last ID inserted) > > Well, for one they can be hard to track / find if you are not the > developer > and have sufficient rights to look at them, they are also a performance > drain when simple constraint should be enough. > > Most cases which use a trigger now are unnecessary. Sounds to me like you're not so much against triggers as for using the right tool for the job. (I've just had my career path review and been told to try and be more positive...) ;^) Jim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203250 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
