[SQLObject] select(orderBy=(-Table.q.field)) bug
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Rick F. <rf...@im...> - 2006-10-13 21:15:51
|
According to the docs: "You can use the keyword arguments orderBy to create ORDER BY in the select statements: orderBy takes a string, which should be the database name of the column, or a column in the form Person.q.firstName. You can use "-colname" to specify descending order, or call MyClass.select().reversed()." source: http://sqlobject.org/SQLObject.html#orderby However, when I tried to use select(orderBy=(-Table.q.field)) the resulting query was like: "ORDER BY - table.field" when it should be "ORDER BY table.field DESC" Last I check using "-column" in the in the defaultOrder set in the sqlmeta class worked for me so I think the problem is just in select.(orderBy=-Table.q.field). Using: SQLObject-0.7.1 Python2.4 PostgreSQL 7.4.13 -- Rick |