Re: sql query works in database connector but not in ZSQL method

"Charlie Clark" <[email protected]> Wed, 17 Jan 2007 16:33:39 +0100

Newsgroups	gmane.comp.web.zope.database
Organization	eGenix.com
Message-ID	<[email protected]>

Am 17.01.2007, 15:42 Uhr, schrieb robert rottermann <[email protected]>:

> Hi there,
> I try the following statement:
> CALL selectVertexProperties(1, @error2)
> when I execute this directly in the test "window" of the database
> connection, it works fine.
> when i execute the same line in the test window of a ZSQL Method
> then I get an error:
> Error, Products.mxODBCZopeDA.ZopeDA.ReplayTransaction: OperationalError
> on : ('HYT00', 2014, "[unixODBC][MySQL][ODBC 3.51
> Driver][mysqld-5.0.26]Commands out of sync; you can't run this command
> now", 6113) SQL used:

Robert,

you might have to call this using the callproc() method of the DA in an  
ExternalMethod.

Charlie