Hello,
I am new to web2py and this group. Would be thankful if someone could
help me to paginate the results/hits of search.
Suppose the following case:
---in models---
db.define_table('table_name',
SQLField('Title','text',),
SQLField('Artist','string',length=256))
-- in Controllers --
def show_records():
form=FORM(TABLE(TR(("",INPUT
(_type="text",_name="searchFor",requires=IS_NOT_EMPTY())),
("",INPUT(_type="submit",_value="Search")))
))
query=(
((db.table_name.Title.like('%%%s%%'
%request.vars.searchFor))
)|(db.table_name.Artist.like('%%%s%%'
%request.vars.searchFor))
results=db.(query).select(distinct=True)
return dict(form=form, results=results)
Now I want to display the results in a paginated form, let us say 10
records per page.
How to do this?
Regards
Salerno
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
