From: Ksenia M. <kse...@gm...> - 2004-12-23 23:14:08
|
> > Please try the attached patch and run > Employee.select(orderBy=Person.q.firstName) > Does it help? Thank you, for the test case it does produce a correct query: SELECT employee.id, employee.position FROM employee, person WHERE (1 = 1 AND (employee.id = person.id)) ORDER BY person.first_name However, it doesn't have effect on another database. There must be some class / table / property combination in it that SQLObject doesn't like. I'll try to locate the problem by starting with very basic tables and adding the rest piece by piece... Thanks! -- Ksenia |