I need to limit my processing of db entries to chunks of, let's say, 100. So I want to first get the data:
data = db(db.mytable.flag == False).select(limitby=(0,100)) for d in data: # do something Then I want to set mytable.flag to True after the above loop is done, but only for the same 100 entries I've just retrieved. BUT, while this is going on, someone else may be adding new entries with mytable.flag=False to the table. So without iterating one-by-one on "data", is there a one-liner to update mytable.flag to True for the 100 entries I already retrieved?