Is there a section in the online web2py book that explains Niphlod's way to building a query?
Near the bottom of this thread<https://groups.google.com/forum/?fromgroups=#!topic/web2py/qL1DKqeEFkA> there is: all_in_one = db( (db.products.id == db.product_filter.product_id) & (db.filters.id == db.product_filter.filter_id) ) Then to get all corresponding rows in product_filter table, all_in_one_hoodies = all_in_one(db.filters.name == "hoodie").select() I understand his cumbersome example, where you have to select a resultset and then pass that to another select(). But I don't understand how I can pass all_in_one() a parameter and how it knows to return all products which have the "hoodie" filter name. -- --- 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.