Hi all i try to personalise sqltable by using following code I am using __setitem__ to generate customize rows in table. this code is working for StartTime Field but not for gameName Field (it just display the html code ). any idea?
db code: ------------------------ db.define_table('games', Field('gameName',default='Game'), Field('StartTime','datetime',default=now) ) Controllers code: ----------------------------- def Mytest(): rows = db().select(db.games.ALL) records=SQLTABLE(getRows(rows), headers='fieldname:capitalize', truncate=100 ) return dict(records=records ) def getRows(rows): for r in rows: r.__setitem__('StartTime', B(str(r['StartTime']))) # This code is working r.__setitem__('gameName', B(str(r['gameName']))) # This code is not working return rows Thanx Frasse