Re: SQL 7 Question

I set SET NOCOUNT ON/OFF outside the BEGIN/COMMIT TRANSACTION and it seems to work fine. Thanks! best, paul At 10:54 AM 5/10/01 +0700, you wrote: * Team Allaire * Thanks! Now that you mention it I did had BEGIN TRANSACTION/COMMIT

Re: SQL 7 Question

The dbms needs to support it, but yeah it's known. I guess the only limit would be the amount of time you want that connection open to the database server. It is not the equivalent to a transaction. I thought so also until Dave Watts corrected me a little while ago ;-) Each different command

Re: SQL 7 Question

Thanks! Now that you mention it I did had BEGIN TRANSACTION/COMMIT TRANSACTION in another version, but I guess it fell down the proverbial crack in this developing application. (Probably a bad copy/paste ;-) I happen to have the SQL below within a CFTRANSACTION of 3 CFQUERIES. They take zip