According to the web2py book, we can use 'count' as a field by first
delcaring a variable:
count=db.mytable.id.count()
Then using it in the select statement:
db().select(db.mytable.somefield,count,groupby=db.mytable.somefield)
Then to access it we use the "_extras" variable:
{{=row._extra[count]}}
Only.... this does not work. After some experimentation I found it
needed to be a little more specific:
{{=row._extra['COUNT(myvar.id)']}}
I thought this should be documented somewhere, and the forum seems to
be the place for this.
-- Joe B.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
