I think what Neil is trying to say is that a Trigger would be unnecessary if the resulting events that need to be executed were programmed in the original SP. I tend to agree with Neil....somewhat....I wouldn't say Triggers are useless, but it seems to me that if proper planning and design are in place, when you want a certain event to occur when something else happens that you would program it intentionally with the original event.
Here's a question on the subject, as I'm not an expert in SQL triggers and SP's by any means....if you execute an SP from CFQUERY does the connection to the database from CF release immediately, even while the SP continues running, or does CF stay connected? If CF stays connected for the entire time an SP is running, then THAT would definitely give a very good reason to use triggers....You set up your primary event in your SP, execute it from CF, and then CF can continue processing doing whatever it needs to do while the trigger takes over. Thoughts? Comments? Corrections? :-) Dave -----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 ****************************************************************************************** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:215598 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
