Thanks. Yes db(~db.table.id.belongs(list)).select()
On Oct 17, 4:11 pm, Joergi <[email protected]> wrote: > Hello, > > I'm playing around with web2py and I'm very happy to find a tool/ > framwork like that. It is exactly what I'm looking for since years. > > One open question from my site. > > Is there a way to do a db query and check that an id is not in a given > range or list. > > something like that: > db(db.table.id.IS_NOT_IN(list)).select() > > Best regards, > Joerg
