That is what BEGIN TRAN is for... ;-)
-----Original Message----- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: 31 May 2005 18:37 To: CF-Newbie Subject: Re: Kinda urgent - Tried to post on the SQL list and it doesn't show Sorry, that should have been live production box. Ray Champagne wrote: > Okay, but this scares me - you're not testing on a live dev box are you? > > Torrent Girl wrote: > >>haven't tried it yet. Since it is a delete proc, I wanted to get the syntax correct first. >> >> >> >> >>>The syntax looks good, but I am by no means a great SQL coder. Just >>>thought that little typo might have been the culprit. >>> >>>What happens when you try it? >>> >>>Torrent Girl wrote: >>> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:15:1062 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
