[web2py] Re: Combining LEFT OUTER JOIN with COUNTING

2010-02-24 Thread aure
It worked fine, thank you! Aurelien (I got it wrong because I had tried instead: count = db.person.id.count()) On Feb 18, 3:19 pm, mdipierro wrote: > Now sure  try > > count = db.dog.id.count() > rows=db().select(db.person.id,db.person.name, count, > left=db.dog.on(db.person.id==db.dog.owner),g

[web2py] Re: Combining LEFT OUTER JOIN with COUNTING

2010-02-18 Thread mdipierro
Now sure try count = db.dog.id.count() rows=db().select(db.person.id,db.person.name, count, left=db.dog.on(db.person.id==db.dog.owner),groupby=db.person.id) print row.person.name, row[count] On Feb 18, 7:03 am, aure wrote: > Hi, > > I have used the methods given in the web2py manual, in the "On