Re: [web2py] conditional update after form is submitted

[Simon Carr]

Hi Vasile,

Thanks for the reply, but that code seems to generate an error

if form.validate(request.vars):
TypeError: validate() takes exactly 1 argument (2 given)


Here is my full function that I am trying to run if it helps

@auth.requires_login()   
def edit_chart():
    record = db.section_charts(request.vars['scid'])
    form = 
SQLFORM(db.section_charts,record,Fields=('title','description','width','position'),deletable=True,hidden=dict(oldposition=record.position))
    if form.validate(request.vars):
        if request.vars['oldposition'] != form.vars['position']:
            sql = "update section_charts set position = position + 1 where 
position >= " + str(form.vars['position'])
            db.executesql(sql)
    if form.process().accepted:
        response.flash = "Chart Updated"
        redirect(URL('manage_dashboard'),client_side=True)
    elif form.errors:
        response.flash = "The forms has errors"
    else:
        response.flash = "Please complete the form"
    return form






On Saturday, 10 November 2012 17:57:10 UTC, Vasile Ermicioi wrote:
>
> if form.validate(request.vars):
>     #your code
>     form.accepts(request.vars) 

--