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
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
