[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, 2012

[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,

[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-5,