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]