I think the easiest way is building virtual fields for that. You can use powerTable plugin, which can do that in JavaScript using this feature of datatables http://datatables.net/examples/api/counter_column.html
virtual fields works in this way: class Virtual(object): def delete(self): return TAG.BUTTON(T('DELETE'),_class='deletebutton',_onclick='deleteRow(event,%s);' % self.products.id) rows = db(db.items.order = order.id).select() rows.setvirtualfields(virtual=Virtual()) Now you got in rows an delete object: for row in rows: print row.virtual.delete Will return the HTML of the delete Button. This might works with SQLTABLE. <http://datatables.net/examples/api/counter_column.html> 2010/12/30 Kenneth Lundström <kenneth.t.lundst...@gmail.com> > Hello list, > > what would be the easiest way to display a Rows object as an table with > some additional info. > > rows = db(db.items.order = order.id).select() gives 3 rows and 10 fields. > > total = 0 > for row in rows > total += rows.sum > > That I悲 like to display data as: > > Item 1 10.50 delete (a link to delete this record) > Item 2 5 delete > Item 3 7.89 delete > Total 23,39 > > Can I do this with SQLTABLE or TABLE and TR? > > > Kenneth > -- Bruno Rocha http://about.me/rochacbruno/bio