On 6 March 2013 08:10, at <[email protected]> wrote: > > Pl consider following select statement: > rows=db().select(db.persons.ALL, db.books.ALL, > left=db.persons.on(db.persons.id==db.books.owner)) > > Want to order by persons.dob, then books.purchased, where both are of type > date/time. >
Did you search the book for orderby? Here is an example from the book: db.person.ALL, orderby=db.person.name|db.person.id): So in your case cat can be rows=db().select(db.persons.ALL, db.books.All, left=db.persons.on(db.persons.id==db.books.owner), orderby = db.persons.dob| db.boks.purchased) Regards Johann -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3) -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
