Re: [SQLObject] Inheritance

[Ksenia M. <kse...@gm...>]

Hi,

I don't understand how to use an orderBy parameter with this version.
Or maybe it's a bug? Given the same example, I can't select employees
and order them by first_name. The statement like this:

Employee.select(orderBy='first_name')

produces:

 SELECT employee.id, employee.child_name FROM employee WHERE  1 = 1
ORDER BY person.first_name

then Postgres reacts to that like  'NOTICE: adding missing FROM-clause
entry for table "person"'

which results in double number of records in the resultset because the
tables are not joined properly.

Thanks
--
Ksenia.