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

[Oleg B. <ph...@ph...>]

On Fri, Feb 05, 2010 at 11:22:29PM +0100, Petr Jake?? wrote:
> PsMessageReaded(id = myId, idEmployee=3, dateAdd =  tStamp)
> 
> When I am trying it, I am getting following error:
> 
>     self._executeRetry(conn, c, q)
>   File
> "/usr/lib/python2.5/site-packages/SQLObject-0.10.1-py2.5.egg/sqlobject/mysql/mysqlconnection.py",
> line 129, in _executeRetry
>     raise ProgrammingError(ErrorMessage(e))
> sqlobject.dberrors.ProgrammingError: Column 'id_message' specified twice

   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.

Oleg.
-- 
     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.