You can secure access to the database, limiting all updates, for example, to that SP.
That should still accomplish the same goal. - Calvin -----Original Message----- From: Russ Michaels [mailto:[EMAIL PROTECTED] Sent: Thursday, August 18, 2005 10:20 AM To: CF-Talk Subject: RE: @@Identity returns excessive records But an SP still has to be triggered by something. And that is really what he is saying, because my example cannot be accomplished just by a SP, unless you implicitly execute that SP every time. Which means your still relying on the ColdFusion code to do so. If someone edits a record directly on the database, then how would that SP get executed. Russ -----Original Message----- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: 18 August 2005 15:07 To: CF-Talk Subject: RE: @@Identity returns excessive records That's not what he's saying. What he's saying is that an SP can accomplish the same goal. The difference is that the SP encapsulates the update and 'triggered' functionality and therefore would receive the updates instead of the table itself. Calvin -----Original Message----- From: Russ Michaels [mailto:[EMAIL PROTECTED] Sent: Thursday, August 18, 2005 10:01 AM To: CF-Talk Subject: RE: @@Identity returns excessive records Neil, You are totally avoiding answering the question. You have stated that an SP can do everything a trigger can do, and you have stated that an SP can automatically be execute when a certain event occurs just like a trigger. So for the 3rd time, please show me how. russ -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 18 August 2005 14:38 To: CF-Talk Subject: RE: @@Identity returns excessive records 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 ;-) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:215610 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