[web2py] kind of newbie question

[Richard Vézina]

Hello,

I would do this :

def grid():
    if request.args[0] in tableSubSet:
        allFieldsSet=set(db['table1'].fields) # all the fields in the table
        fieldsBlackListSet=set(['f1ToRem','f2ToRem','f1ToRem']) # fields to
be remove from the grid
        allFieldsSet-=fieldsBlackListSet # removing fields to be removed
        fieldsRequested=[]
        for field in allFieldsSet:
            fieldsRequestedList.append('db.test_activity.'+field) # building
the select list of elements

        a=','.join(fieldsRequestedList) # transform the list into a string

        rows = db().select(a) # BLOCKED BECAUSE OF THE QUOTES
(*'*db.table1.field1,
db.table1.field2, etc.*'*)!!!
        table=SQLTABLE(rows)
        return dict(table=table)

Thanks for your help.

Richard