how to use Not belongs

[Pradeesh]

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. 

[lyn2py]

I can't test it here, but did you use

db.table1.field2

instead of

field2

?

[Bruno Rocha]

use the unary ~ operator

db(~db.table1.field1.belongs(array)).update(field2=False)

Bruno Rocha
www.rochacbruno.com.br

--
 
 
 

[Cliff Kachinske]

Bruno's method is correct.

With Postgres and psycopg2, make sure the array variable is not empty or wrap it in a try...except block.