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

Reply via email to