Wait, do you mean that you did the sum as part of the select? What exactly did you return to the view (the whole Rows object), and how do you want to display the results? In general, you would access the sum "field" like rows[row_number]['SUM(t_table.f_field)']. Note, you can also assign the sum to a variable prior to the select and then use the variable name to access the sum from the Rows object -- see http://web2py.com/book/default/chapter/06#belongs (sum is discussed right after belongs).
On Thursday, October 20, 2011 1:27:02 AM UTC-4, andrej burja wrote: > > in controler i do join and sum > the result si rows object > in response._vars the sum is displayed in > SUM(t_table.f_field) > > what is the syntax to display that in view? > > andrej >
