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

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 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

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

On Wed, Jan 17, 2007 at 03:42:04PM +0100, robert rottermann wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 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.

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

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

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

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Charlie Clark schrieb: 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

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

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kevin Campbell schrieb: On Wed, Jan 17, 2007 at 03:42:04PM +0100, robert rottermann wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi there, I try the following statement: CALL selectVertexProperties(1, @error2) when I execute this

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

On Wed, Jan 17, 2007 at 05:18:05PM +0100, robert rottermann wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kevin Campbell schrieb: On Wed, Jan 17, 2007 at 03:42:04PM +0100, robert rottermann wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi there, I try the following

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

Am 17.01.2007, 17:14 Uhr, schrieb robert rottermann [EMAIL PROTECTED]: If tried that, but somehow I did not get it rigth: questions: - - the first parameter is an integer, how do I force that? int(para) ? - - the second parameter is an out parameter, how do I specify that ? You don't, I

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

On 2007-01-17 17:42, Charlie Clark wrote: Am 17.01.2007, 17:14 Uhr, schrieb robert rottermann [EMAIL PROTECTED]: If tried that, but somehow I did not get it rigth: questions: - - the first parameter is an integer, how do I force that? int(para) ? - - the second parameter is an out

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

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Charlie Clark schrieb: Am 17.01.2007, 17:14 Uhr, schrieb robert rottermann [EMAIL PROTECTED]: If tried that, but somehow I did not get it rigth: questions: - - the first parameter is an integer, how do I force that? int(para) ? I of course

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

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Robert, Looks very much like an issue due to transactions. Are you using auto-commit on either the MySQLdb connection or the zope database adapter? Perhaps you could test the issue by placing get_transaction().commit() before the start of

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

robert rottermann wrote at 2007-1-17 15:42 +0100: ... 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: