Syntax question: db(db.mytable.id == request.post_vars["id"]).update(**{key:value})

[Henk huisman]

Is this correct syntax?

if request.post_vars["id"]:
        for key, value in request.post_vars.items():
      db(db.mytable.id == request.post_vars["id"]).update(**{key:value})

[Niphlod]

I'd loop collecting the needed updates in a dict and then issue a single update at the end with the **dict

[Henk huisman]

Thanks,

I wrote this code and seems to work well...from an ajax call.

Post is with or without id; depending on if its a new record or an update

def save_selected():

    a={} 

    if request.vars["id"]:

        for key, value in request.vars.items():

            if key!="id":

                a[key]=value

        db(db.mytable.id == request.vars["id"]).update(**a)

    else:

        for key, value in request.vars.items():

            a[key]=value

        db.mytable.insert(**a)

    return