recap: - db.table1.ALL is just a shortcut to db.table1.field1, db.table1.field2, db.table1.field3, etc etc etc - select() without arguments selects all fields for all tables involved. - if you pass something explicit to select() , you get just what you asked for
tl;dr : exactly what you observed. ALL is useful, e.g., when you need all fields of table1 but only some fields of table2. Instead of doing select(*db.table1.field1, db.table1.field2, db.table1.field3, db.table1.field4, db.table1.field5, * *db.table2.field1, db.table2.field2* ) you can do select(*db.table1.ALL*, *db.table2.field1, db.table2.field2*) -- --- 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.