Re: [web2py] Re: DAL and JOINS error

2013-10-22 Thread Diogo Munaro
O...Ok, thanks Anthony! 2013/10/22 Anthony > On Tuesday, October 22, 2013 3:22:09 PM UTC-4, Diogo Munaro wrote: > >> But the book is wrong? >> Here: http://web2py.com/books/**default/chapter/29/06/the-** >> database-abstraction-layer?**search=join#Inner-joins

[web2py] Re: DAL and JOINS error

2013-10-22 Thread Anthony
On Tuesday, October 22, 2013 3:22:09 PM UTC-4, Diogo Munaro wrote: > But the book is wrong? > Here: > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=join#Inner-joins > What do you see wrong in the book? Note, using the WHERE clause still does an inner join,

[web2py] Re: DAL and JOINS error

2013-10-22 Thread Diogo Munaro
But the book is wrong? Here: http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=join#Inner-joins Em terça-feira, 22 de outubro de 2013 13h09min07s UTC-2, Anthony escreveu: > > db(db.city.name.contains('rio') & db.city.state_id == db.state.id).select( >> db.city.na

[web2py] Re: DAL and JOINS error

2013-10-22 Thread Anthony
> > db(db.city.name.contains('rio') & db.city.state_id == db.state.id).select( > db.city.name,db.city.id,db.state.name) db(db.city.name.contains('rio') & db.city.state_id == db.state.id) should be: db(db.city.name.contains('rio') & (db.city.state_id == db.state.id)) In python, the & takes pre