[Zope-DB] sql query works in database connector but not in ZSQL method

[Charlie Clark]

Am 17.01.2007, 15:42 Uhr, schrieb robert rottermann <robert at redcor.ch>:

> 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