Is it possible to update a Rows object with another Rows object?

[João Matos]

Is it possible to update a Rows object with another Rows object?

I would like to do something similar to this (except that update does not exist in Rows)

rows = db(db.wo.id == int(request.args[0])).select()
if len(request.args) > 1:
    for id_ in request.args[1:]:
        rows.update(db(db.wo.id == int(id_)).select()

[João Matos]

The solution is simply to add them :)

http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Combining-rows

Got help in the Telegram Web2py International Support Group at https://t.me/web2py_world/

[Anthony]

Why not a single query to get all records:

rows = db(db.wo.id.belongs(request.args)).select()

Anthony

 

[João Matos]

Thanks Anthony. I found out about belongs after posting.