yep, it was 3 though. Basically CF does not like it for some reason...its just freaks.
-----Original Message----- From: Tom Smith [mailto:[EMAIL PROTECTED] Sent: 22 July 2003 10:45 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] CF5 / SP problem are you returning 2 queries from the sp? ----- Original Message ----- From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 22, 2003 10:32 AM 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]
