[web2py] Re: update table from sqlform

2013-12-06 Thread Anthony
I don't think this is documented, but when dealing with a join, you have to specify the table in order to use .update_record(). So, it would be: record.organization.update_record(**db.organization._filter_fields(form.vars )) Anthony On Thursday, December 5, 2013 6:50:33 AM UTC-5, Yebach wrote:

Re: [web2py] Re: update table from sqlform

2013-12-06 Thread Johann Spies
Are you using SQLFORM or SQLFORM.factory? Regards Johann -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https

[web2py] Re: update table from sqlform

2013-12-05 Thread Yebach
Hello > > I am trying to update records in user profile from form > > I have two tables that need to be updated > > auth_user and organization > > record = db((db.auth_user.organization==db.organization.id) & ( > db.auth_user.id == uid)).select().first() > > if form.process().accepted: >