Yes obviously, but how does the SP know that a column is updated and execute itself?
-----Original Message----- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: 18 August 2005 14:02 To: CF-Talk Subject: RE: @@Identity returns excessive records The SP can update the record and perform related tasks... -----Original Message----- From: Russ Michaels [mailto:[EMAIL PROTECTED] Sent: Thursday, August 18, 2005 8:57 AM To: CF-Talk Subject: RE: @@Identity returns excessive records And how would you make a SP execute when a column is updated without using a trigger? Russ -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 18 August 2005 13:40 To: CF-Talk Subject: RE: @@Identity returns excessive records Yep, which is where SP's come in. -----Original Message----- From: Russ Michaels [mailto:[EMAIL PROTECTED] Sent: 18 August 2005 13:37 To: CF-Talk Subject: RE: @@Identity returns excessive records Well I use the rule. Don't get coldfusion to do the work of the database, when the database can obviously do it a lot better. Russ -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 18 August 2005 13:15 To: CF-Talk Subject: RE: @@Identity returns excessive records What kind of trigger? There may be cases where you MUST use them - as in, you have no other options. Triggers have an unnecessary overhead on the server - If you are performing selects in them then you should use a trigger. If your DB has been designed well you can get away with "default" cascading. -----Original Message----- From: Russ Michaels [mailto:[EMAIL PROTECTED] Sent: 18 August 2005 13:07 To: CF-Talk Subject: RE: @@Identity returns excessive records Well I find them very handy. For example. I have a trigger that detects when a client account is deactivated, and then automatically deactivates all other records in related tables as well. No different than using the cascade update and delete triggers that are there by default. Russ This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:215583 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
