Oops, when I was testing it, I thought I could do this: fields = (db.test.id,db.test.ref,db.test.descr) db(db.test.id>0).select(fields).as_list()
It seems that I have to do this: db(db.test.id>0).select(db.test.id,db.test.ref,db.test.descr).as_list() Sorry for confusion!