On Sun, 28 Jan 2001, Lee wrote:
2- MySQL DBA. I'm not responsible for installing Zope or the MySQL DBA on the Unix machine but from what I understand, people have had a few problems working with MySQL DBA. What problems can I expect?
The main problem seems to be that there are three distinct versions of ZMySQLDA available: 1.1.3 - very old version which uses MySQLmodule-1.4, which is also very old. There may be a 1.1.4 which has been adapted to use MySQLdb. 1.2.x - a somewhat newer version designed to use MySQLdb (not sure what the status is of this) 2.0.4 - my version, derived from the ZOracleDA, adapted to use MySQLdb-0.3.x. Issues: Returns INTEGER columns as Python longs (by design, to avoid overflows on INTEGER UNSIGNED columns), and Python 1.5.2 appends an L when converting to a string with str(). Can't put in your own LIMIT clause unless you set max_rows on the Z SQL Method to zero; max_rows=0 with no LIMIT clauses returns zero rows instead of all of them (fixed in upcoming MySQLdb-0.3.2, will not require a ZMySQLDA update). -- Andy Dustman PGP: 0xC72F3F1D @ .net http://dustman.net/andy "Normally with carbonara you use eggs, but I used lobster brains instead." -- Masahiko Kobe (Iron Chef Italian): 30-year-old Giant Lobster Battle