[web2py] Re: In praise of the lowly "nested_select"

Sorry for the delay in replying. The first step is to create a Select object, rather than an Expression. Look again at the code: subq = db(dbts.id>0).nested_select(dbts.ALL,...etc) This creates a Select object. The Select object implements "on". (Table also implements "on", but not Expressio

[web2py] Re: In praise of the lowly "nested_select"

Sorry I didn't see this question earlier. The "on" attribute is on the Table object. If you look at the code, I use variables like dbt = db.times This allows me to use "dbt.xxx" to access the Table object directly. I find it a convenient syntactic shorthand because I'm always using it to get

[web2py] Re: In praise of the lowly "nested_select"

Hello ! Very interesting !!! I'm trying to reproduce this behaviour but I'm getting this error "Expression object has no attribute on". What version of w2p are you using ? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code)