+-------[ Jon Franz ]----------------------
|
| +-------+--------------+------+-----+---------+----------------+
| | Field | Type | Null | Key | Default | Extra |
| +-------+--------------+------+-----+---------+----------------+
| | id | mediumint(8) | | PRI | 0 | auto_increment |
| | value | varchar(32) | | | | |
| +-------+--------------+------+-----+---------+----------------+
|
| Now, at first i thought it was the field name of 'id' causing
| the problem, but now I've tried renaming the field and its still a no-go.
| I can do queries such as 'select value from reason' fine, but if i select
| * or the id field, it chokes... Looking through the mailinglist archives,
| I think its a 'mapping error' where the ZmySQLDA doesn't properly map
| this type of field for some reason... can someone help me solve this
| problem?
The problem is likely to be your mediumint field, which is probably not
mapped to a python type.
You should let us know what version of MySQL DA you have.
Also be aware that the DA is not a part of Zope, and has been contributed
by a 3rd party.
Anyway if you want to have a crack at fixing it, look in the
ZMySQLDA directory in a file called db.py. You could add an entry with
"medium int":"i"
or permutations of the above. (You can test it I can't, so little point in
me doing it when its this simple).
--
Totally Holistic Enterprises Internet| P:+61 7 3870 0066 | Andrew Milton
The Internet (Aust) Pty Ltd | F:+61 7 3870 4477 |
ACN: 082 081 472 ABN: 83 082 081 472 | M:+61 416 022 411 | Carpe Daemon
PO Box 837 Indooroopilly QLD 4068 |[EMAIL PROTECTED]|
_______________________________________________
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )
