> > In the example you give in your first post you seems to have forget the > field you want to make a constraint for... > > in db(db.tablename.fieldname == something).select(...) this part > "db.tablename.fieldname == something" is equal to "where > tablename.fieldname = something" in raw SQL... > > If you want all the record from a table for example : > > db(db.tablename.id > 0).select(db.tablename.ALL) >
Note, there's a shortcut for the above: db(db.tablename).select() Behind the scenes, it is converted to db.tablename._id > 0. I would think db(db['tablename']) would work exactly the same. Anthony
