unordered list and pagination

[Annet]

I have an address book controller with a function that queries the database for addresses:

rows=db((db.Organization.nodeID==db.NodeKeyword.nodeID)&(db.Organization.nodeID==db.Address.nodeID)&\
(db.Organization.approved==True)&(db.NodeKeyword.word==request.vars.word)&\
(db.Address.locality==request.vars.locality)&(db.Address.addrType==PHYSICALADDR))\
.select(db.Organization.nodeID,db.Organization.name,db.Address.ALL,orderby=db.Organization.name)

In the view I'd like to do something like:

<ul>
<li>
Organization.name
Address.address
Address.postal-code Address.locality
</li>
<li>
Organization.name
Address.address
Address.postal-code Address.locality
</li>
<li>...</li>
</ul>

I'd like to display 12 addresses per page, so I need pagination. I had a look at the examples in the book, but I don't see how they make an unordered list page-able.

I hope one of you could provide me with a working example, or different approach to solve the problem.

Kind regards,

Annet

[Annet]

Is there a way to implement this using twitter bootstrap's pagination component: http://twitter.github.com/bootstrap/components.html


Annet.

[Massimo Di Pierro]

def index():

     query = (db.Organization.nodeID==db.NodeKeyword.nodeID)&(db.Organization.nodeID==db.Address.nodeID)&\
(db.Organization.approved==True)&(db.NodeKeyword.word==request.vars.word)&\
(db.Address.locality==request.vars.locality)&(db.Address.addrType==PHYSICALADDR)

     fields = (db.Organization.nodeID,db.Organization.name,db.Address.ALL)

     orderby = db.Organization.name

     grid = SQLFORM.grid(query,fields=fields,orderby=orderby,sortable=False,

                                             create=False,deletable=False,editable=False,

                                             searchable=False,paginate=12)

     return dict(grid=grid)

[Annet]

Massimo,

Thanks for your reply. I like the solution, however, it results in the following ticket:

Traceback (most recent call last):
  File "/Library/Python/2.5/site-packages/web2py/gluon/restricted.py", line 205, in restricted
    exec ccode in environment
  File "/Library/Python/2.5/site-packages/web2py/applications/bootstrap/controllers/addressbook.py", line 45, in <module>
  File "/Library/Python/2.5/site-packages/web2py/gluon/globals.py", line 173, in <lambda>
    self._caller = lambda f: f()
  File "/Library/Python/2.5/site-packages/web2py/applications/bootstrap/controllers/addressbook.py", line 26, in index
    grid=SQLFORM.grid(query,fields=fields,orderby=orderby,sortable=False,create=False,deletable=False,editable=False,searchable=False,paginate=12)
  File "/Library/Python/2.5/site-packages/web2py/gluon/sqlhtml.py", line 1515, in grid
    field_id = tables[0]._id
IndexError: list index out of range

Kind regards,

Annet

[Massimo Di Pierro]

Please try trunk version (you appear to be using an older version). If the problem persists open a google code ticket about this.

massimo

[Annet]

Massimo,

Please try trunk version (you appear to be using an older version). If the problem persists open a google code ticket about this.

I tried the trunk version, now I get another error:

 

Traceback (most recent call last):
  File "/Library/Python/2.5/site-packages/web2py/gluon/restricted.py", line 205, in restricted
    exec ccode in environment

  File "/Library/Python/2.5/site-packages/web2py/applications/bootstrap/controllers/addressbook.py", line 56, in <module>
  

File "/Library/Python/2.5/site-packages/web2py/gluon/globals.py", line 173, in <lambda>
    self._caller = lambda f: f

()
  File "/Library/Python/2.5/site-packages/web2py/applications/bootstrap/controllers/addressbook.py", line 21, in indexindex
    searchable=False,paginate=12)
  File "/Library/Python/2.5/site-packages/web2py/gluon/sqlhtml.py", line 1517, in grid
    buttonexport='icon downarrow',
AttributeError: 'SQLALL' object has no attribute '_tablename'


Kind regards,

Annet

[Massimo Di Pierro]

can you show us addressbook.py around linke 56?

[Annet]

Massimo,

Sorry, I clicked the post button, before writing a reply. In the old Google Groups I had the option to remove a post, it seems to no longer be available.

Anyway, line 56 is the first empty line at the end of addressbook.py

When I create an empty controller and just put the following function in it:

# coding: utf8

def index():
    query=(db.Organization.nodeID>2033)
    fields=(db.Organization.name)
    orderby=db.Organization.name
    grid=SQLFORM.grid(query,fields=fields,orderby=orderby,sortable=False,create=False,deletable=False,editable=False,\
    searchable=False,paginate=12)
    return dict(grid=grid)


I get this ticket when executing the function:

Traceback (most recent call last):
  File "/Library/Python/2.5/site-packages/web2py/gluon/restricted.py", line 205, in restricted
    exec ccode in environment

  File "/Library/Python/2.5/site-packages/web2py/applications/bootstrap/controllers/mock.py", line 11, in <module>
  

File "/Library/Python/2.5/site-packages/web2py/gluon/globals.py", line 173, in <lambda>
    self._caller = lambda f: f

()
  File "/Library/Python/2.5/site-packages/web2py/applications/bootstrap/controllers/mock.py", line 8, in index
    searchable=False,paginate=12)
  File "/Library/Python/2.5/site-packages/web2py/gluon/sqlhtml.py", line 1577, in grid
    if field._tablename in tablenames]
AttributeError: 'Expression' object has no attribute '_tablename'


Kind regards,

Annet

[Massimo Di Pierro]

    fields=(db.Organization.name)

should be

    fields=(db.Organization.name, ) # <<< the commma

or

    fields=[db.Organization.name]

[Annet]

Massimo,

Thanks for helping me solve the problem. This:

    fields=(db.Organization.name, ) # <<< the commma

... doesn't work. It had to be:

    fields=[db.Organization.name]

 
Kind regards,

Annet.