orderby ascending or descending

[DenesL]

I need to obtain a SQLRows object sorted in descending order, is that
option missing?.

If yes, this should be an easy mod since it only requires to include
the optional ASC or DESC spec at the end of the ORDER BY in the SQL
statement.

[mdipierro]

db().select(orderby=db.table.field) ORDERS ASCENDING
db().select(orderby=~db.table.field) ORDERS DESCENDING
db().select(orderby=~db.table.field|db.table.otherfield)
ORDERS DESCVENDING in field ASCENDING in otherfield

You can also do

db().select(orderby="...")

WHERE "..." is an SQL order by option.

[DenesL]

copy/paste... LOL...
What a coincidence!
I posted my question at exactly the same time you were answering it.

[DenesL]

Where in the source do you accomplish that?.
I was looking in the gluon.sql module but I can't see it.

[mdipierro]

yes, I can barely keep up...

Mind that I may be slow or down in the next 2 days....

[DenesL]

IMHO you are doing and excellent job.
Thank you for your efforts.

[Massimo Di Pierro]

It is in there: in SQLSet methods select() and SQLXorable

btw, you can also do

orderby=db.table.field.upper()

and

orderby=db.table.datefield.month()

and combinations thereof.

Massimo

[Massimo Di Pierro]

thanks.