Re: [web2py] How to preserve order for query results

Thanks, it worked! Had to change idx to ids though. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed t

Re: [web2py] How to preserve order for query results

On Tue, Mar 15, 2016 at 11:20:04PM -0700, mfarees.kny...@gmail.com wrote: > I have a list, > ids = [2, 3, 1, 4] > When I use this list in a query, like this: > db(db.test.id.belongs(ids)).select() > I get results sorted by id, like (1, 2, 3, 4), but what I want is the exact > order that I

[web2py] How to preserve order for query results

I have a list, ids = [2, 3, 1, 4] When I use this list in a query, like this: db(db.test.id.belongs(ids)).select() I get results sorted by id, like (1, 2, 3, 4), but what I want is the exact order that I sent i-e (2, 3, 1, 4) Is there any way to achieve this easily in web2py? -- Resource