> Thanks for you help Paul. Actually, this doesn't fail in cf5. The SET > NOCOUNT allows for multi sql statements (in MS SQL). Thanks for your
i guess thats ODBC vs JDBC "quirks". i use SET NOCOUNT w/mx but this is the only time i've seen it fail. > Moving to a stored proc does fix the problem; however, that is an > impossibility with some of our queries - plus it would be a major re-write. whatever but sp are most often a better way of doing these sorts of things in the 1st place. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.394 / Virus Database: 224 - Release Date: 3/10/2545 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
