It appears to be a limitation of the M$ jdbc driver. Now using the jTDS driver and all works well and with the same performance improvements (specifically, reduced memory usage). Hoorah for OSS!
Dominic On 1 February 2010 13:23, Leigh <[email protected]> wrote: > > > <cfquery datasource="my-datasource" name="my-query"> > > UPDATE foo SET bar = 1 > > > > SELECT bar FROM foo > > </cfquery> > > Any difference if you surround the entire block with a SET NOCOUNT ON/OFF? > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330294 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
