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]

Reply via email to