it's explained here: http://web2py.com/books/default/chapter/29/06#Many-to-many
Den tisdagen den 21:e maj 2013 kl. 22:02:00 UTC+2 skrev [email protected]: > > 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
