Dear list,
I am trying to create a search form to access a table in database and then
return a table of result into a view (same page), but displaying only 3
records and next/prev buttons to scroll over results (e.g. I want to have
pagination of the table display results). I am trying to follow an example
from http://web2py.com/books/default/chapter/29/14/other-recipes#Pagination,
but have some issues.
My code in default.py is:
def search():
rows = None
page = 7 # fixing for a moment
items_per_page = 3 # fixing for a moment
form=FORM('Tool name:',
INPUT(_name='name', _id='name', requires=IS_NOT_EMPTY()),
INPUT(_type='submit'))
if form.accepts(request,session):
response.flash = 'form accepted'
if request.vars:
rows =
db(db.mytools.name.contains(request.vars.name)).select(db.mytools.name,
db.mytools.description)
elif form.errors:
response.flash = 'form has errors'
else:
response.flash = 'please fill the form'
return dict(form=form, rows=rows, page=page,
items_per_page=items_per_page)
If I have in search.html following code, everything works:
{{=form}}
{{=rows}}
but as soon as I try (the example from tutorial)
{{for i,row in enumerate(rows):}}
{{if i==items_per_page: break}}
{{=row.value}}<br />
{{pass}}
{{if page:}}
<a href="{{=URL(args=[page-1])}}">previous</a>
{{pass}}
{{if len(rows)>items_per_page:}}
<a href="{{=URL(args=[page+1])}}">next</a>
{{pass}}
I have an error "NoneType' object is not iterable"
What am i doing wrong? (i am newbie to web2py, so sorry if i have super
obvious code errors).
Thanks a lot,
Anna
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
