> -----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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203247 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
