I recently switched to using the latest Microsoft JDBC Driver for MSSQL 2005 and immediately saw a performance increase (over using the standard driver w/ ColdFusion 8.01). However, all our queries that have multiple statements are failing so I've had to switch back. e.g.
<cfquery datasource="my-datasource" name="my-query"> UPDATE foo SET bar = 1 SELECT bar FROM foo </cfquery> With the standard built in driver I can reference my-query.bar, with the MS JDBC Driver I cannot (get a 'bar is undefined in my-query' error). Has anyone experienced this? Is there a way to enable multiple statements using the jdbc driver? I've checked this page out and couldn't see anything that fit the bill: http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=datasources_ADV_MJS_11.html TIA Dominic ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:330292 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4