The correct syntax is: db(query).select( fields_to_include ) You can find the details at: http://web2py.com/book/default/chapter/06#Query,-Set,-Rows
as for db.select(db.table.id>1) I would expect it to create a ticket due to a KeyError since db as no select method. 2011/7/28 António Ramos <[email protected]> > correction > the first returns what i want and the second returns all records but they > are empty > > > > Em 28 de julho de 2011 13:11, António Ramos <[email protected]>escreveu: > > hello >> >> why >> db(db.table.id>1).select() is diferent from db.select(db.table.id>1) >> >> the first returns what i want, the second returns all >> >> >> thank you >> António >> > >
