Re: [web2py] Update many rows at once separately

[Bruno Rocha]

You can try something like this:

def test():
    rows = db(db.test).select()
    return dict(rows=rows)

def update_level():
    for key, value in request.post_vars:
        try:
            db.table[key].update_record(level=value)
        except:
            # do something if key is invalid.
    db.commit()
    redirect("URL TO REDIRECT AFTER UPDATES")  # or use ajax

Now in views/controller/test.html

<form action="{{=URL("update_level")}}" method="POST">
   <table>
   {{for row in rows:}}
   <tr> <td>{{=row.name}}</td><td> *<input type="text" value="" id="{{=
row.id}}" name="{{=row.id}}" />*</td></tr>
   {{pass}}
   </table>
</form>


On Wed, Aug 22, 2012 at 3:16 PM, Fabiano Faver <far...@gmail.com> wrote:

> |     name      |          level          |
> ----------------------------------
>       test 1      |    combobox(0)   |
>       test 2      |    combobox(1)   |
>       test 3      |    combobox(0)   |
>              ________
>              |  Submit  |
>              -------------
>

--