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.


Reply via email to