+-------[ 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 |akm@theinternet.com.au|