erm, that makes no difference at all. and in fact is simply a message handler.
-----Original Message----- From: Oliver Tomkins [mailto:[EMAIL PROTECTED] Sent: 22 July 2003 10:54 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] CF5 / SP problem You could do with adding SET NOCOUNT ON at the top of the stored proc as well. -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 22 July 2003 10:33 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] CF5 / SP problem this is what we were doing as well...believe me we have tried everything and it always kills CF....if we take the last select out and place it in a new sp or call it inline it works fine...? -----Original Message----- From: Tom Smith [mailto:[EMAIL PROTECTED] Sent: 22 July 2003 10:28 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] CF5 / SP problem neil, create a local var and assign the @@identity to it when in the transaction block, then run the local variable again the second sql statement e.g. delcare @new_id int BEGIN TRANSACTION > INSERT INTO > SELECT > > DELETE FROM > > SELECT @new_id = @@IDENTITY > > COMMIT > > SELECT WHERE @new_id I've not tested this, but it should work for you! let us all know if this works for you. Cheers, TOM ----- Original Message ----- From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 22, 2003 10:11 AM Subject: [ cf-dev ] CF5 / SP problem > We have an sp which runs AOK in Query Analyser yet when its ran via > ColdFusion it crashes it - and I mean a total reboot. > > I will provide some pseudo code first to see if anyone has had this > problem.. > > --------------------------- > BEGIN TRANSACTION > INSERT INTO > SELECT > > DELETE FROM > > SELECT @@IDENTITY > > COMMIT > > SELECT WHERE @@IDENTITY > > > > The last SELECT seems to be causing the problem as when you remove it from > the SP it works AOK....but when its in it freak la sheek's? > > Wierd non? > > If you need code, let me know and I will post it on. > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
