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

[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 

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.