Thanks Johann, it works. :) I'd tried it earlier but was getting some errror. I hadn't realized that it was due to some other problem.
Regards On Wednesday, 6 March 2013 11:33:09 UTC+5, Johann Spies wrote: > > On 6 March 2013 08:10, at <[email protected] <javascript:>> 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.
