[web2py] Re: Is there a way to use an Alias for a COUNT() field

2012-05-13 Thread Massimo Di Pierro
You can still do rows.json() even if you add columns to rows or you change their values. On Saturday, 12 May 2012 00:27:49 UTC-5, Franklin Freitas wrote: > > If I use what you recommend then what would be the best way to generate > the JSON output > > Thanks Massimo > > > On Saturday, May 12, 20

[web2py] Re: Is there a way to use an Alias for a COUNT() field

2012-05-11 Thread Franklin Freitas
If I use what you recommend then what would be the best way to generate the JSON output Thanks Massimo On Saturday, May 12, 2012 12:29:09 AM UTC-4:30, Massimo Di Pierro wrote: > > No, but you can do > > for row in rows: row['count'] = row[count] > > > > On Friday, 11 May 2012 23:44:57 UTC

[web2py] Re: Is there a way to use an Alias for a COUNT() field

2012-05-11 Thread Massimo Di Pierro
No, but you can do for row in rows: row['count'] = row[count] On Friday, 11 May 2012 23:44:57 UTC-5, Franklin Freitas wrote: > > Having the following > > def by_country(): > count = db.procesados.idpublicacion.count() > rows = db().select(db.procesados.pais, count, > groupby=db.