paginate should work. http://web2py.com/books/default/search/29?search=paginate

________________________________________
Kiran Subbaraman
http://subbaraman.wordpress.com/about/

On Tue, 04-03-2014 4:49 PM, John Philip wrote:
Dear forum,

sorry for asking this basic question. I would like to limit the number of rows in a query 'passlist' which I want to show in a SQLFORM grid. I did try using limitby but this caused a syntax error. I only saw it being used in select queries. Any help would be appreciated.

passlist = (db.nextpasses.BOT>=windowTT)
    sgrid = SQLFORM.grid(passlist)

many thanks,

John
--
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/groups/opt_out.

--
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/groups/opt_out.

Reply via email to