[web2py] Re: Pagination with two queries

If the provinces are mutually exclusive (is that the case), of course there won't be any records that match both of them. Do you perhaps want to use "||" instead? On Friday, May 2, 2014 7:01:02 AM UTC-4, Ruud Schroen wrote: > > I tried that, it returns zero results.. > > Also when i print the qu

[web2py] Re: Pagination with two queries

I tried that, it returns zero results.. Also when i print the query, this comes out: ((kamernet.province = 'Limburg') AND (kamernet.province = 'North Brabant')) > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - ht

[web2py] Re: Pagination with two queries

please try (not tested): query = (db.kamernet.province == 'Limburg') & (db.kamernet.province == 'North Brabant') best regards, stifan On Friday, May 2, 2014 5:45:15 PM UTC+7, Ruud Schroen wrote: > > Hi, > > I'm trying to use the pagination from web2py_utils with two queries. > Usually the code