On Tue, Apr 24, 2007 at 07:49:14AM -0400, David Turner wrote:
> I can't figure out how to make SQLObject order by multiple columns. Is
> this possible? It seems like Table.select(query).orderBy("col1 asc,
> col2 desc") or something ought to just work, but SQLObject rejects it.
> Any ideas?
orderBy() requires a list:
Table.select(query).orderBy(["col1 asc", "col2 desc"])
Table.select(query).orderBy([Table.q.col1, DESC(Table.q.col2)])
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
