Re: [web2py] Re: order by surname, name

2011-02-03 Thread Johann Spies
On 3 February 2011 16:49, Marin Pranjic wrote: > + you can use ~ to reverse order. > > > http://web2py.com/book/default/chapter/06#orderby,-groupby,-limitby,-distinct > > > On Thu, Feb 3, 2011 at 2:21 PM, dederocks wrote: > >> Hi Johann, >> >> Just use "|": >> orderby=db.table.name|db.table.surn

Re: [web2py] Re: order by surname, name

2011-02-03 Thread Marin Pranjic
+ you can use ~ to reverse order. http://web2py.com/book/default/chapter/06#orderby,-groupby,-limitby,-distinct On Thu, Feb 3, 2011 at 2:21 PM, dederocks wrote: > Hi Johann, > > Just use "|": > orderby=db.table.name|db.table.surname > > On 3 fév, 13:56, Johann Spies wrote: > > According to the

[web2py] Re: order by surname, name

2011-02-03 Thread dederocks
Hi Johann, Just use "|": orderby=db.table.name|db.table.surname On 3 fév, 13:56, Johann Spies wrote: > According to the book the syntax to create an  'order by'  query is > db(query).select(ALL,orderby=field). > > What if I want to use more than one field in the 'order by' ? > > Regards > Johann