Re: [web2py] Re: Show "count()" result in view

2018-12-29 Thread Jon Subscripted
Thanks guys. That's exactly what I needed. Sorry I was not able to fint it myself... Regards, Jon. On Sat, Dec 29, 2018 at 4:19 AM Anthony wrote: > See > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Grouping-and-counting > . > > On Friday, December 28, 2018 at 6:4

Re: [web2py] Re: Show "count()" result in view

2018-12-28 Thread 黄祥
pardon, not sure got what you want to achieve think if you want to count the rows data, should it better to count the data first (using compute in table constructor or count it manually before insert to the table) before put it on table? or do the count calculation manually on the fly (on the vie

Re: [web2py] Re: Show "count()" result in view

2018-12-28 Thread Jon Subscripted
Thanks Stifan, I see how can I do that for the whole query. How can I do this row-wise? Can I create a "count_db" variable per row? As I'm grouping by game and counting how many entries I have per game (after grouping them), I would like to show the count per row. The closest I got so far is by p