***************************** 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