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_selectorproperty.id==db.css_declaration.selectorproperty_id)&
\
(db.css_declaration.bedrijf_id==auth.user.bedrijf_id)&(db.css_selectorproperty.inquery==True)),
\
orderby=db.css_selectorproperty.id)
... results in this:
SELECT css_selectorproperty.id, css_selectorproperty.selector,
css_selectorproperty.property, css_selectorproperty.name,
css_selectorproperty.inquery, css_declaration.id,
css_declaration.bedrijf_id, css_declaration.selectorproperty_id,
css_declaration.value FROM css_selectorproperty LEFT JOIN
css_declaration ON
((css_selectorproperty.id=css_declaration.selectorproperty_id AND
css_declaration.bedrijf_id=263) AND css_selectorproperty.inquery='T')
ORDER BY css_selectorproperty.id;
I think the problem has something to do with the parenthesis in the ON
part of the query, but I am unable to trace it back to the parenthesis
in the function. I hope I provided you with sufficient information to
help me solve the problem.
Kind regards,
Annet.
