Hi I got two tables Books and Authors Book(Name,List:Author,...) each book has at least one author now I want to have a list of all the books one Author has written. So I came up with this line of code: l=db(db.Books.Author.contains(Author.id)).select(db.Books.ALL, orderby=db: Books.Name) which works but it only gives me one Book per Author. I got no clue why this happens I know that I have several Authors which have more than one book.
-- 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.