What you are stating and what the process is are two different beasts.....your trigger is simply a lazy way to monitor a process which you are not doubt firing as part of what I would assume is a cfquery. Why don't you just throw that update into an SP and handle the whole shebang in the SP? You would have the original status and the new status and the success of the process.
Anything a trigger can do, normal SQL can do (almost anyway ;-) -----Original Message----- From: Russ Michaels [mailto:[EMAIL PROTECTED] Sent: 18 August 2005 14:30 To: CF-Talk Subject: RE: @@Identity returns excessive records So your saying that an SP can automatically detect that data in a specific column has changed (as per my trigger example) and execute itself to update all the others. I am very interested to see how this is done. Please show me some example code. Russ -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 18 August 2005 14:12 To: CF-Talk Subject: RE: @@Identity returns excessive records Easy...SP updates record, get success status, sp (or other sp) is called and does related tasks. Job done....no mess, no fuss. -----Original Message----- From: Russ Michaels [mailto:[EMAIL PROTECTED] Sent: 18 August 2005 13:57 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 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:215590 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
