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]

Reply via email to