Can you show the results from the query > > SHOW COLUMNS FROM ps_message_readed > ? > > I suspect column names are in uppercase there, and fromDatabase > machinery has problems finding the id column. Because of the column > 'id_message' is used twice - once from id and once from the list of > columns.
I have a function for something like this: def printColumnNames(aTable): print "col.origName", "\t", "col.dbName" for col in aTable.sqlmeta.columnList: print col.origName, "\t", col.dbName col.origName col.dbName idMessage id_message idEmployee id_employee dateAdd date_add Is that what you mean? ------------------------------------------------------------------------------ The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss