[web2py] Re: CRUD.search sorting order

2011-05-07 Thread villas
Hi Niknok This was indeed confirmed as a problem which has now been fixed by Massimo. You would have to download the latest version of the file tools.py from the 'trunk' in google code. Regards, D On May 6, 2:00 pm, niknok wrote: > Thanks for the response Villas. > > Do note that my use of >  

[web2py] Re: CRUD.search sorting order

2011-05-07 Thread villas
Issue 264. On May 6, 5:59 pm, Massimo Di Pierro wrote: > Please open an issue in google code > > -- Forwarded message -- > From: villas > Date: May 6, 10:56 am > Subject: CRUD.search sorting order > To: web2py-users > > Hi Niknok > > I have looked at this in a little more detail

[web2py] Re: CRUD.search sorting order

2011-05-06 Thread Massimo Di Pierro
Please open an issue in google code -- Forwarded message -- From: villas Date: May 6, 10:56 am Subject: CRUD.search sorting order To: web2py-users Hi Niknok I have looked at this in a little more detail now.  The main problem seems to be that web2py does not accept the orderby

[web2py] Re: CRUD.search sorting order

2011-05-06 Thread villas
Hi Niknok I have looked at this in a little more detail now. The main problem seems to be that web2py does not accept the orderby argument for crud.search. ** I believe this is a bug ** I think it should be possible to fix this easily enough in tools.py but it is best if someone with more exper

[web2py] Re: CRUD.search sorting order

2011-05-06 Thread niknok
Thanks for the response Villas. Do note that my use of fields=['id','last_name','first_name', ... is based on examples in the book . I tried your suggestions, sadly, I'm getting a KeyError error message. W2P complaining about the "db.auth_user" table names... Have you tried this out yourself an

[web2py] Re: CRUD.search sorting order

2011-05-04 Thread villas
I should have also said that I think the fields should be fields and not strings: i.e. fields = [db.auth_user.id, db.auth_user.last_name, ] On May 4, 2:47 pm, niknok wrote: > I'm using v1.94.6 and retrieving ordered search results from crud.search > always produces a list sorted by id > > T

[web2py] Re: CRUD.search sorting order

2011-05-04 Thread villas
Did you try the orderby fields without the .lower() ? I don't think you can do that. On May 4, 2:47 pm, niknok wrote: > I'm using v1.94.6 and retrieving ordered search results from crud.search > always produces a list sorted by id > > Tried various combinations: > >     orderby=db.auth_user.last_