Hello Richard, if I understood correctly, you want:
... BlackList = [ 'fieldx', 'fieldy', ...] rows = db().select(*[f for f in db['table1'].fields if f not in BlackList]) ... Denes On Oct 19, 6:14 pm, Richard Vézina <[email protected]> wrote: > 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
