Some of the information here may be outdated, please check the book instead

Yes it is correct

query1=(db.table.field==value)|(db.table.field==other_value) is a SQLQuery

db(query1) is a SQLSet

db(query1)(query2) is a subset, the same as set defined by


They are equivalent notations.

In a SQLSet you can:

  • db(query1).select(db.table.field)
  • db(query1).delete()
  • db(query1).update(field=value)
© 2008-2010 by Massimo Di Pierro - All rights reserved - Powered by web2py - design derived from a theme by the earlybird
The content of this book is released under the Artistic License 2.0 - Modified content cannot be reproduced.