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 <[email protected]> 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 [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.
