I can't test it here, but did you use db.table1.field2 instead of field2
? On Monday, August 13, 2012 4:21:28 PM UTC+8, Pradeesh wrote: > > 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. > --
