I have the following code:

rows=db(db.node.computedSubClass!=SC_CONSUMER).select(db.node.ALL,db.groups.ALL,left=db.groups.on((db.node.id==db.groups.nodeID)&(db.groups.type!=RELATEDNAMES)))

I'd hoped that this would exclude groups of type RELATEDNAMES of rows, 
however, the code sets all fields of db.groups.ALL to None and includes 
them in rows.

How do I get rows without groups of type RELATEDNAMES using a left join.


Kind regards,

Annet

-- 

--- 
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.


Reply via email to