El viernes, 9 de agosto de 2013 12:01:18 UTC-3, Jose escribió: > > Hi > > This is a simplification (the select is more complex and involves many > left join) > > suma = tb_lotes.superficie.sum() > > rows = db(qry).select( > ... > ... > (suma / tb_establecimientos.superficie) * 100, > ... > left=[...], > groupby=... > ) > > if return records (return rows), the calculated field is shown as > > ((SUM(lotes.superficie) / establecimientos.superficie) * 100.0) > > The question I have is how access to this field when iterate over rows: > > for r in rows: > r.??? > > I used it once, but do not remember how. > > José > > It was very simple:
r['((SUM(lotes.superficie) / establecimientos.superficie) * 100.0)'], Jose -- --- 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/groups/opt_out.
