Re: [SQLObject] how to get id (primary key) from database

[Petr J. <pet...@tp...>]

  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?