[web2py] Re: left outer join and condition [CLOSED]

2010-09-30 Thread annet
Massimo, Thanks, problem solved. I also got a better understanding of the left join now. Kind regards, Annet.

[web2py] Re: left outer join and condition

2010-09-30 Thread annet
Massimo, Thanks, problem solved. I also got a better understanding of the left join now. Kind regards, Annet.

[web2py] Re: left outer join and condition

2010-09-30 Thread mdipierro
The problem is that you select css_selectorproperty and left join css_selectorproperty. Yet you send a condition about the primary table "db.css_selectorproperty.inquery==True" in the codition about the left join. It should be db(db.css_selectorproperty.inquery==True).select(db.css_selectorpropert

[web2py] Re: left outer join and condition

2010-09-30 Thread annet
Massimo, > can you > > print db(...)._select(...) > > with _select but same query as yours and see what you get? This: @auth.requires_membership('card') def manage_css(): print db()._select(db.css_selectorproperty.ALL,db.css_declaration.ALL,\ left=db.css_declaration.on((db.css_selectorprop

[web2py] Re: left outer join and condition

2010-09-30 Thread mdipierro
can you print db(...)._select(...) with _select but same query as yours and see what you get? On Sep 30, 3:07 am, annet wrote: > In my model I defined the following tables: > > db.define_table('css_selectorproperty', >     Field('selector',length=48,default='',notnull=True), >     Field('proper