I'm just curious: don't you need to separate the statements with semicolons? I've never seen multiple SQL statements without semicolons before.
As others have noted tho', this behavior is driver-specific anyway... Sean On Mon, Feb 1, 2010 at 4:29 AM, Dominic Watson <[email protected]> wrote: > > 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:330313 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
