yeah we've had this problem with 2 return queries, and we found that when we ran the sp in query analyser, it was fine, then in CF it would break cf, but the sql server was fine??? are these similar to your simptoms? ----- Original Message ----- From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 22, 2003 10:45 AM Subject: RE: [ cf-dev ] CF5 / SP problem
> 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] -- ** 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]
