sigh... so I just realized that the if form.process().accepted actually processes the form. No words to express my embarrassment right now lol..
Thank you for the help, Richard! On Friday, March 27, 2015 at 12:10:12 PM UTC-4, Richard wrote: > > haha!! > > You need to read... > > http://web2py.com/books/default/chapter/29/07/forms-and-validators#FORM > > Then : > > http://web2py.com/books/default/chapter/29/07/forms-and-validators#SQLFORM > > In particular form processing : > > > http://web2py.com/books/default/chapter/29/07/forms-and-validators#The-process-method > > Add this below your form : > > if form.process(session=None, formname='test').accepted: > response.flash = 'form accepted' > elif form.errors: > response.flash = 'form has errors' > else: > response.flash = 'please fill the form' > > > Also, instead of calling your form "grid" why use missleading variable > name... Call it "form" > > If you keep grid, change the variable name accordingly in the aboce code > extract from the bookkk > > Richard > > > > On Fri, Mar 27, 2015 at 11:56 AM, LoveWeb2py <atayl...@gmail.com > <javascript:>> wrote: > >> Ahhh that makes great sense. Learn something new all the time. Thank you, >> Richard! >> >> right now here is my code: >> def unique_view(): >> >> prefs_id = db(db.unique_view_peruser.auth_user_id == auth.user_id). >> select(db.unique_view_peruser.id) >> >> if len(prefs_id) == 1: >> prefs_id = prefs_id.id >> else: >> prefs_id = None >> grid = SQLFORM(db.unique_viewperuser, prefs_id) >> return dict(grid=grid) >> >> This does not insert anything into the database >> Do I need to update the database after SQLFORM? >> I could use something like db.unique_viewperuser.insert(insert values) >> if the form is accepted. I thought when SQLFORM goes into create mode it >> would create the database automatically and insert the values >> automatically. Am I wrong? >> >>> >>>> >>> -- >> 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 web2py+un...@googlegroups.com <javascript:>. >> 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
