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<http://db.organization.name/>
,db.Address.ALL)
orderby = db.Organization.name <http://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)
On Sunday, 8 April 2012 03:00:26 UTC-5, Annet wrote:
>
> 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
>
