use the unary ~ operator db(~db.table1.field1.belongs(array)).update(field2=False)
Bruno Rocha www.rochacbruno.com.br Em 13/08/2012 05:21, "Pradeesh" <[email protected]> escreveu: > In my control I have an array with so many values. > I want to write a dal query to update a table rows which having ID not in > this array. > > I want something like this. > db(db.table1.field1.notbelongs(array)).update(field2=False) > > I have tried like this > db(db.table1.field1 not in(array)).update(field2=False) > but this is not working fine. It is throwing an error as raise > RuntimeError, "No table selected" > > I would greatly appreciate any suggestions. > > -- > > > > --
