Try replace form.accepts (request.vars,session)
with form.accepts (request.post_vars,session) or simply form.accepts (request,session) On Dec 14, 10:11 am, DenesL <[email protected]> wrote: > The problem is the use of 'id' in the vars. > What happens is that the form already has an 'id' field, although it > is hidden it is still being sent back on submit, and then you add > another 'id' in the vars so you end up with two, hence '|1|1|'. > > To fix just use a variable name that is not in the form. > > On Dec 13, 5:38 pm, Seamon <[email protected]> wrote: > > > Hi, > > > I've just experienced strage behaviour while using SQLFORM to update > > records > > in MySQL DB. The code is pretty basic (see below), just a little > > cookbook application > > and this part was ment to edit the recipe. First all seemed ok - the > > form was displayed > > as specified, but after submitting the changes I kept getting error > > like this: > > ValueError: invalid literal for int() with base 10: '|1|1|' > > > Where the |1|1| was clearly connected to the record id. For some > > reason the form.accept > > was ignored and the whole result from the form submit came in as an > > request (so it contained an id > > but it was '|1|1|') and that was the problem. Apparently it can be > > fixed with some type checking, but > > it shouldn't by working like this as far as I know. Any idea why this > > happens? > > > DB Table: > > cbook.define_table ('recipe', > > Field ('Food_Name','string',length = 40), > > Field ('id_author','integer',default = -1), > > Field ('creation_date','date'), > > Field ('suroviny','text'), #resources > > Field ('popis','text'), #info > > Field ('postup','text'), #recipe > > Field ('verejny','boolean') #public > > ) > > Code: > > def edit_recipe(): > > if session.authorized: > > > id = request.vars.id > > record=cbook(cbook.recipe.id==id).select() > > > form = SQLFORM (cbook.recipe,submit_button='Uloz > > zmeny',record=record[0],showid=False,fields = > > ['Food_Name','popis','suroviny','postup','verejny'] ) > > > if form.accepts (request.vars,session): > > response.flash = 'Recipe updated' > > redirect(URL(r=request,c='recipes',f='edit_recipe',vars = > > {'id':id})) > > > return dict (form=form,id=id) > >
