I recently moved my product from zope 2.2.5 with ZMySQLDA 1.1.4 and
MySQLDB 0.1.2 to a Zope 2.3.0b3 with new mysql code (MySQL-python-0.3.0,
and ZMySQLDA 2.0.1).  With these changes, I've found a couple problems,
and was wondering if others where familiar with any of these problems,
if some might be configuration issues.

1) All field values appear as strings in python
This is the issue I hope is my own configuration mistake.  Using the old
product, field values where auto-converted to compatible python types;
so int fields would be int's in python, not strings.  This has broken
many things in my product, and although I can patch all my queries to
call int()/float()/etc on the results, there is code in MySQL-python to
auto-convert field values.

2) select ...  limit a[,b]
This doesn't work anymore, and that just appears to be a bug in
ZMySQLDA.  I have a patch if anyone is interested.  (Problem is that
DB.query() adds a limit clause to the query, based on the max_rows
argument.  This makes windowing (using two arguments with limit)


Zope maillist  -  [EMAIL PROTECTED]
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-dev )

Reply via email to