This is covered in the book: http://web2py.com/books/default/chapter/29/06#Logical-operators.
Note, you deleted your earlier post, but the problem there wasn't adding WHERE clauses -- it was a failure to specify an inner join<http://web2py.com/books/default/chapter/29/06#Inner-joins>where you needed one. Anthony On Monday, July 1, 2013 10:34:44 AM UTC-4, lesssugar wrote: > > 1. What's the proper way to use [AND, OR] in DAL's where clauses? Do I use > [and / &&], [or / ||] ? > > 2. Does using commas is the equivalent of AND? Like in: > > row = db(db.table.field_1 == X, db.table.field_2 == Y, db.table.field_3 ==Z > ).select() > > > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
