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

2007-01-19 Thread Charlie Clark
Am 19.01.2007, 17:50 Uhr, schrieb robert rottermann [EMAIL PROTECTED]: it in deed seems not to work. however I do not understand why. If you use callproc() we could probably help you. This is now academical as I resolved to not to use stored procedures that return a record set (tough its a

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

2007-01-18 Thread robert rottermann
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 hi there, I think I found the reason, for my problems with stored procedures. it seems that on can not call a stored MySQL 5.0x procedure from zope that returns a data set. when I call the body of the stored procedure everything works fine. what I

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

2007-01-18 Thread Charlie Clark
Am 18.01.2007, 17:58 Uhr, schrieb robert rottermann [EMAIL PROTECTED]: I think I found the reason, for my problems with stored procedures. it seems that on can not call a stored MySQL 5.0x procedure from zope that returns a data set. If you use the mxODBC Zope DA callproc() method then you