[web2py] Can't serialize select result with fields from two or more tables in JSON

2011-04-20 Thread Rafael Sales
rBy) return response.json({'despesas': despesas, 'servicos': servicos}) So... is this a bug? Rafael Sales

[web2py] Re: new web2py version

2011-04-20 Thread Rafael Sales
Please check my post: http://groups.google.com/group/web2py/browse_thread/thread/21357d1dc85cbeed It can be a bug. :) On 21 abr, 00:29, Massimo Di Pierro wrote: > Please help me check the nightly build from the web2py download page. > I would like to release a new stable version next week so tha

[web2py] Re: Can't serialize select result with fields from two or more tables in JSON

2011-04-21 Thread Rafael Sales
By the way, I'm using Ubuntu 10.10 and the current version of Web2Py: 1.94.6 On 21 abr, 13:31, Franzé Jr. wrote: > I think so > > On Apr 20, 6:09 pm, Rafael Sales wrote: > > > Hello, > > I'm facing a very tricky error with JSON. > > I have an action

[web2py] How to rename column name of a projection on select

2011-04-22 Thread Rafael Sales
Hello, How can I define the column name of a field which is a projection (like sum()) on select? Examplo: query = ((db.despesa.id_servico == db.servico.id)) total_gasto = (db.despesa.valor_servico * db.despesa.quantidade).sum() linhas = db(query).select(db.servico.descricao