That what I thought! How do you validate your form??
Please read the book a bit more about form submission... http://web2py.com/books/default/chapter/29/07/forms-and-validators#SQLFORM def display_form(): form = SQLFORM(db.person) if form.process().accepted: response.flash = 'form accepted' elif form.errors: response.flash = 'form has errors' else: response.flash = 'please fill out the form' return dict(form=form) You need to process the form, see if it validate... You shouldn't have to insert manually your data if you don't need facy thing and form.process().accepted should handle everything for you. Richard On Mon, May 5, 2014 at 10:03 AM, LoveWeb2py <[email protected]> wrote: > Sorry forgot to add .iteritems(): this is the most updated version. > > > On Monday, May 5, 2014 10:01:46 AM UTC-4, LoveWeb2py wrote: > >> Hi Richard, >> >> Here is what I have so far: >> >> Controllers: >> def user_list(): >> grid=SQLFORM.smartgrid(db.users, paginate=20, >> links_placement='left', _href=URL('transition_form', vars=dict((f, row[f]) >> for f in db.users.fields))))], user_signature=True) >> return dict(grid=grid) >> >> def transition_form(): >> for f, v in request.vars.iteritems(): >> >> db.table[f].default = v >> form = SQLFORM(db.table, user_signature=True) >> return dict(form=form) >> >> View: >> user_list.html >> {{=form}} >> >> This properly populates the values. but it isn't submitting properly. >> After the form submits I would like it to return to the database and show >> me the user that was just added. Also, I set my database to autoincrement >> the ID which should solve the "id problem" >> >> I was thinking I could set something in my transition_form function that >> if form.process().accepted: redirect(URL('user_list')), but I get an error >> saying table object has no attribute '_formkey' does this mean I need to do >> some type of form validation? >> >> On Monday, May 5, 2014 9:53:38 AM UTC-4, Richard wrote: >>> >>> Please show code!! >>> >>> Richard >>> >>> >>> On Mon, May 5, 2014 at 8:50 AM, LoveWeb2py <[email protected]> wrote: >>> >>>> Also, >>>> >>>> When I click the submit button in {{=form}} it doesn't actually submit >>>> anything. It just doubles the values that are already in the fields and >>>> puts them into a list. I think I need to do something like db.insert with a >>>> new ID number for the submit button. >>>> >>>> >>>> On Monday, May 5, 2014 8:46:25 AM UTC-4, LoveWeb2py wrote: >>>>> >>>>> Richard/Niphold, >>>>> >>>>> Thank you so much. It's almost done. Just getting attribute error now >>>>> but I am going to try to fix that with exception handling. >>>>> >>>>> <type 'exceptions.AttributeError'> 'str' object has no attribute 'year' >>>>> >>>>> I have a modified_on field which is set to datetime. WHen I comment >>>>> that out it transfers to the next page with no problem. Any thoughts on >>>>> how >>>>> I could fix? >>>>> >>>>> On Sunday, May 4, 2014 9:10:55 AM UTC-4, Richard wrote: >>>>>> >>>>>> Sorry for miss leading, Niphold is true... >>>>>> >>>>>> So, >>>>>> >>>>>> for f, v in request.vars.iteritmes(): >>>>>> db.table[f].default = v >>>>>> >>>>>> >>>>>> On Sat, May 3, 2014 at 8:47 AM, Niphlod <[email protected]> wrote: >>>>>> >>>>>>> request.vars is like a dict. Surely you're hitting that issue :-P >>>>>>> >>>>>>> >>> test = dict(a=1,b=2) >>>>>>> >>> for k,v in test: >>>>>>> ... print k, v >>>>>>> ... >>>>>>> Traceback (most recent call last): >>>>>>> File "<stdin>", line 1, in <module> >>>>>>> ValueError: need more than 1 value to unpack >>>>>>> >>> >>>>>>> >>>>>>> Add an "iteritems()" and you're good to go >>>>>>> >>>>>>> >>> for k,v in test.iteritems(): >>>>>>> ... print k,v >>>>>>> ... >>>>>>> a 1 >>>>>>> b 2 >>>>>>> >>>>>>> >>> >>>>>>> >>>>>>> On Friday, May 2, 2014 11:20:40 PM UTC+2, LoveWeb2py wrote: >>>>>>>> >>>>>>>> Web2py admin console has a red line at for f, v in request.vars: >>>>>>>> and then says too many values to unpack. >>>>>>>> >>>>>>>> my function is def transition_form(): >>>>>>>> for f, v in request.vars: >>>>>>>> db.table[f].default = v >>>>>>>> form = SQLFORM(db.table, user_signature=True) >>>>>>>> return dict(form=form) >>>>>>>> >>>>>>>> Should I have extra values in the dict method? >>>>>>>> >>>>>>> -- >>>>>>> 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 [email protected]. >>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>> >>>>>> >>>>>> -- >>>> 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 [email protected]. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- > 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 [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
