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
> > TRANSACTION in another version, but I guess it fell down the proverbial
> > crack in this developing application.  (Probably a bad copy/paste ;-)
>
>if you shove a bunch of TSQL statements into one cfquery you have to
>enclose them all in SET NOCOUNT ON/OFF block to prevent cf from
>thinking its getting valid resultsets everytime sql server sends back "x
>rows
>selected" messages. in fact, for most sp its a good idea to shave a few ms
>here & there...
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to