all fields are stored into a "special" key named _fields on the table. So, e.g., you could do (not tested)
fields = [db.auth_user[f] for f in db.auth_user._fields if f != 'first_name' ] db(db.auth_user.id>0).select(*fields) to select all of them except 'first_name' Il giorno giovedì 27 dicembre 2012 13:52:53 UTC+1, Ramos ha scritto: > > how can i select all fields from a query except field "F1" using DAL? > > Thank you > António > --