This works indeed, and I can build an SQLTABLE based on the rows now. Thank you.
Consequence is that SQLFORM.grid or smart grid cannot be used in this case? (since there is no "select" statement possible, as it just takes a query?) Op zaterdag 27 juni 2015 22:47:34 UTC+2 schreef villas: > > I think you need to use the distinct like this: > > rows = db(q).select(db.person.firstname, db.person.familyname, > distinct=True) > -- 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/d/optout.
