[web2py] Re: DAL db(db.table.id>1).select() diferent from db.select(db.table.id>1)

2011-07-29 Thread Massimo Di Pierro
I am surprised the second works at all. It should not. I will add a check in the code to raise an exception. On Jul 28, 7:11 am, António Ramos wrote: > 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 >

Re: [web2py] Re: DAL db(db.table.id>1).select() diferent from db.select(db.table.id>1)

2011-07-28 Thread António Ramos
Ok, my mistake! 2011/7/28 Miguel Lopes > 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 sin

Re: [web2py] Re: DAL db(db.table.id>1).select() diferent from db.select(db.table.id>1)

2011-07-28 Thread Miguel Lopes
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 > c

[web2py] Re: DAL db(db.table.id>1).select() diferent from db.select(db.table.id>1)

2011-07-28 Thread António Ramos
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 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