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 <[email protected]>
> 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
