El domingo, 28 de junio de 2015, 10:06:53 (UTC+2), Davy Jacops escribió: > > Villas's solution works indeed, and I can build an SQLTABLE based on the > rows now. > Thank you. (orderby is not required) > > 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?) > > You can use SQLFORM.grid, using for example the "links" optional attribute (although there may be a more efficient way. But first, what do you want? If you have the following results for the join:
1. "John Doe has a dog" 2. "John Doe has a cat" 3. "John Doe has a snake" do you expect the grid to display one line? User Pets John Doe dog, cat, snake or do you want to take the first entry and ignore the rest or what? -- 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.
