def Authors():
AL=db().select(db.Author.ALL, orderby=db.Author.Name)
TheList=[]
for Author in AL:
l=db(db.Book.Author.contains(Author.id)).select(db.Book.ALL, orderby
=db.Book.Name)
if len(l)>0:
TheList.append([l[0]])
else:
TheList.append([])
return dict(AL=AL,BookList=TheList)
here is my controller funktion
and my view:
<table>
{{i=0}}
{{for Author in AL:}}
<tr>
<td>{{=Author.Name}}</td><td></td>
</tr>
{{for b in BookList[i]:}}
<tr>
<td></td><td>{{=b.Name}}</td>
</tr>
{{pass}}
{{i+=1}}
{{pass}}
</table>
its supposed to give an alphabetical list of all authors which it does.
and list all their books (only one is displayed)
--
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/groups/opt_out.
