This is the controller:
def year():
sum_of_entries = db.mydiary.id.count()
years = db(db.mydiary.id > 0).select(sum_of_entries, db.mydiary.Date.
year(), groupby=db.mydiary.Date.year())
# years = db(db.mydiary.id > 0).select(db.mydiary.Date.year(),
distinct=True)
return locals()
This is the view:
<div class="well">
{{=sum_of_entries}}
{{=years}}
</div>
It only outputs:
COUNT(mydiary.id)
Please help.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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/d/optout.
