How to display the results of this query
in my controller i have this query:
def location():
sum_of_entries = db.mydiary.id.count()
distinct_loc = db(db.mydiary.id > 0).select(sum_of_entries, db.mydiary.
Location, groupby=db.mydiary.Location)
# distinct_loc = db(db.mydiary.id > 0).select(db.mydiary.Location,
distinct=True)
return locals()
I want to display each record in below format:
<ul>
<li class="list-group-item">*Location*<span class="badge pull-right">
*Count*</span></li>
</ul>
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
