Help on using "where" select parameter

[Tomas Schertel]

How can I create a db select using two "where"?
Is this right?

results = db.select('mytable', where="id>100 and active=1")

Thanks.

[John Fulton]

Perhaps you're looking for this?

http://webpy.org/cookbook/where_dict

or you could just write your sql string explicitly and do this:

db.query(sql)

John





--
  John

[Tomas Schertel]

Holly cow. I just missed this page!
Thanks a lot (again) Jon.

On Wednesday, 6 June 2012 13:00:04 UTC-3, fultonj wrote: