Re: [web2py] Re: Join on a join on a join on a.... eesh...

2010-10-09 Thread Jason Brower
One more thing, I put the auth.user.id in place of the db.auth_user table and it selectd the single user... Very nice indeed! Best Regards, Jason On 10/10/2010 08:13 AM, Jason Brower wrote: Ooops, yeah, that was easy! I think I am getting it now. Best Regards, Jason Brower On 10/09/2010 10:2

Re: [web2py] Re: Join on a join on a join on a.... eesh...

2010-10-09 Thread Jason Brower
Ooops, yeah, that was easy! I think I am getting it now. Best Regards, Jason Brower On 10/09/2010 10:21 PM, ron_m wrote: There is something wrong with the line in your last version of users_advertisements. For clarity I put one condition per line users_advertisements = db((db.auth_user.id==db

[web2py] Re: Join on a join on a join on a.... eesh...

2010-10-09 Thread ron_m
There is something wrong with the line in your last version of users_advertisements. For clarity I put one condition per line users_advertisements = db((db.auth_user.id==db.user_tags.user_id) & (db.user_tags.tag_id==db.tag.id) & (db.advertisement.id == db.advertisement_tags.advertisement_id) &

Re: [web2py] Re: Join on a join on a join on a.... eesh...

2010-10-09 Thread Jason Brower
I tried... users_advertisements = db((db.auth_user.id==db.user_tags.user_id) & (db.user_tags.tag_id==db.tag.id) & (db.advertisement.id == db.advertisement_tags.advertisement_id) == (db.tag.id == db.advertisement_tags.tag_id)).select()' and it works until I use select() In additon to these I ne

[web2py] Re: Join on a join on a join on a.... eesh...

2010-10-09 Thread ron_m
The last statement is between two db(condition1 & condition2) as in db(condition1 & condition2) & db(condition3 & condition4) Why not make this statement and try it db(condition1 & condition2 & condition3 & condition4).select() Ron On Oct 9, 11:09 am, Jason Brower wrote: >      #Get the users t