I have table with too much cols.
So, is there a way to pass variable names and values in the insert()
or update() methods like this?


    options_house =
db(db.company_houses_options.company_id==company.id).select().first()
    if request.vars.edit_options_house:
        houses_options={}
        for column_name in houses_columns:
            if request.vars.get(column_name, None):
                houses_options[column_name]=True
            else:
                houses_options[column_name]=False
        options_house.update_record(houses_options)

where houses_columns is a list of columns names like
['street','house','block','buildyear',...]

Reply via email to