Re: [web2py] Problem with limitby?

2016-12-12 Thread Scott Hunter
I am using the same orderby whether using limitby or not, as I stated. Thus, using orderby alone, I should get the same first 20 records in the same order as I would get by using limitby(0,20); I am not (again, as shown) In fact, I get the same sequence using limitby(0,20) as appears on the f

Re: [web2py] Problem with limitby?

2016-12-12 Thread Richard Vézina
Hello Scott, I am not sure I understand the problem... But for sure limit by alone will never return you the same set of results as you didn't specify the order in which you want the result to be and the analyser just favor the faster quering path... So don't expect limitby alone to return the sam

[web2py] Problem with limitby?

2016-12-11 Thread Scott Hunter
I'm using a SQLFORM.grid, using a query of the form: db.t_dog.id.belongs(dog_ids) But the listing is erratic; some records only appear when the list is sorted certain ways (except for the last page); entries on each page are in order, but entries between pages overlap. I thought the prob