Hi, I'm trying to use the pagination from web2py_utils with two queries. Usually the code looks like this:
query = db.table.id > 0 count = db(query).count() results = db(query).select(orderby=~db.table.created_on) orderby = ~db.table.id pcache = (cache.ram, 15) paginate = web2py_utils.paginate.Pagination(db, query, orderby, display_count=10, cache=pcache, r=request, res=response) results=paginate.get_set(set_links=True) But i need to use this query: query = db.kamernet.province == 'Limburg' and db.kamernet.province == 'North Brabant' I get no error, however, when i use the OR operator, it only returns records with the province "Limburg", when i use the AND operator it only returns records with "North Brabant". I could use a select() query but then i get this error: OperationalError: near ",": syntax error Anyone know how i can fix this? -- 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 to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
