Yeah, I put up a patch on the MySQLDb Sourceforge page a long time ago for that. Doing almost the same thing. Only I made it so you specify the client flag in the Zope connection object. Doesnt do any good for windows though, they still have a problem with the mysql lib. (I think I posted a bug on that too)
<br><br>Greg<br><br><div><span class="gmail_quote">On 1/16/06, <b class="gmail_sendername">Cameron Beattie</b> <<a href="mailto:kjcsb@orcon.net.nz">kjcsb@orcon.net.nz</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I was getting the following error when attempting to call a stored procedure<br>via a Z SQL Method:<br>_mysql_exceptions.OperationalError: (1312, etc<br><br>So I made the following change to<br>/usr/lib/zope/lib/python/Products/ZMySQLDA/db.py:
<br> def _parse_connection_string(self, connection):<br> kwargs = {'conv': self.conv,<br> 'client_flag': 65536 #inserted by CSB<br> }<br><br>I then restarted Zope. I can now successfully call stored procedures. There
<br>may be a better way to do it. Feel free to advise if so.<br><br>Apologies if this information has already been posted.<br><br>Cameron<br><br>_______________________________________________<br>Zope maillist - <a href="mailto:Zope@zope.org">
Zope@zope.org</a><br><a href="http://mail.zope.org/mailman/listinfo/zope">http://mail.zope.org/mailman/listinfo/zope</a><br>** No cross posts or HTML encoding! **<br>(Related lists -<br> <a href="http://mail.zope.org/mailman/listinfo/zope-announce">
http://mail.zope.org/mailman/listinfo/zope-announce</a><br> <a href="http://mail.zope.org/mailman/listinfo/zope-dev">http://mail.zope.org/mailman/listinfo/zope-dev</a> )<br></blockquote></div><br><br clear="all"><br>-- <br>
Greg Fischer<br>1st Byte Solutions<br><a href="http://www.1stbyte.com">http://www.1stbyte.com</a>