Hello I am having problems integrating my query in to my paginate code using
web2py_utils.
query = db(db.product.id > 0).select(db.product.ALL,
groupby=db.product.category)
orderby = db.product.product_name
pcache = (cache.ram, 15)
paginate = Pagination(db, query, orderby,
display_count=9, cache=pcache, r=request,
res=response)
# Now we get our subset.
rows=paginate.get_set(set_links=True)
this query does not work but if I use
query = db.product.id > 0
it works no problem
Something I am not doing right.. My first query does work with out the
pagination
Any ideas *cheers
