Re: [web2py] Pagination

[Web2Py Freak]

*This is the example in the book  , how can i edit it to fit my table 
"db.blogpost"  ?*


db = DAL 
<http://www.web2py.com/book/default/docstring/DAL>('sqlite://primes.db')
db.define_table('prime',Field 
<http://www.web2py.com/book/default/docstring/Field>('value','integer'))
def isprime(p):
    for i in range(2,p):
        if p%i==0: return False
    return True
if len(db().select(db.prime.id))==0:
   p=2
   for i in range(1000):
       while not isprime(p): p+=1
       db.prime.insert(value=p)
       p+=1

*
*

*
*


def list_items(): if 
len(request<http://www.web2py.com/book/default/docstring/request>
.args): page=int(request<http://www.web2py.com/book/default/docstring/request>
.args[0]) else: page=0 items_per_page=20 limitby=(page*items_per_page,(page+
1)*items_per_page+1) rows=db().select(db.prime.ALL,limitby=limitby) return 
dict(rows=rows,page=page,items_per_page=items_per_page)

Notice that this code selects one more item than is needed, 20+1. The extra 
element tells the view whether there is a next page.

Here is the "default/list_items.html" view:

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.

{{extend 'layout.html'}}

{{for i,row in enumerate(rows):}}
{{if i==items_per_page: break}}
{{=row.value}}<br />
{{pass}}

{{if page:}}
<a href="{{=URL 
<http://www.web2py.com/book/default/docstring/URL>(args=[page-1])}}">previous</a>
{{pass}}

{{if len(rows)>items_per_page:}}
<a href="{{=URL 
<http://www.web2py.com/book/default/docstring/URL>(args=[page+1])}}">next</a>
{{pass}}