Re: found reason: sql query works in database connector but not in ZSQL method
robert rottermann <[email protected]>
| Newsgroups | gmane.comp.web.zope.database |
|---|---|
| Message-ID | <[email protected]> |
-----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 now do as an interim solution, I call the "read only" procedures directly from python. procedures that alter data i call from a zope connector. I would be glad to here of any reason not to do this. thanks for your help. robert -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iD8DBQFFr6c9GaryJ0T9kUYRAlkiAJ9TZ3rKw3iiTHuZ1fiQuJE6Sdoa0wCfZr63 uNOpVr8pc+rYV6jwbZ9l6sI= =p3jD -----END PGP SIGNATURE-----