Re: [web2py] Short way to update or insert data from SQLFORM.factory into the main db.my_table ??? ...

2012-06-26 Thread Don_X
Thank you Bruno I believe it would of work but ... I get an error ... type 'exceptions.SyntaxError' Field email_check does not belong to the table I think it is because I check the email entered in the SQLFORM.factory form and the field e-mail_check does not exist in the table it is

Re: [web2py] Short way to update or insert data from SQLFORM.factory into the main db.my_table ??? ...

2012-06-26 Thread Anthony
db.auth_user.insert(**db.auth_user._filter_fields(form.vars)) That will filter out the fields that don't belong to the table. Anthony On Tuesday, June 26, 2012 8:12:39 AM UTC-4, Don_X wrote: Thank you Bruno I believe it would of work but ... I get an error ... type

Re: [web2py] Short way to update or insert data from SQLFORM.factory into the main db.my_table ??? ...

2012-06-26 Thread Don_X
Hello Anthony, ... I have tried the suggested line of code ... the following way, based on my function index(): in the controller the filter field is 'email_check' so I have entered : db.auth_user.insert(**db.auth_user.email_check(form.vars)) but I get an error msg ! .. should I put it in

Re: [web2py] Short way to update or insert data from SQLFORM.factory into the main db.my_table ??? ...

2012-06-26 Thread Anthony
On Tuesday, June 26, 2012 6:17:58 PM UTC-4, Don_X wrote: Hello Anthony, ... I have tried the suggested line of code ... the following way, based on my function index(): in the controller the filter field is 'email_check' so I have entered :

Re: [web2py] Short way to update or insert data from SQLFORM.factory into the main db.my_table ??? ...

2012-06-26 Thread Le Don X
Amazing ! .. Viva python .. viva web2py ! This is pretty cool stuff ! thanks Anthony .. 2012/6/26 Anthony abasta...@gmail.com On Tuesday, June 26, 2012 6:17:58 PM UTC-4, Don_X wrote: Hello Anthony, ... I have tried the suggested line of code ... the following way, based on my function

[web2py] Short way to update or insert data from SQLFORM.factory into the main db.my_table ??? ...

2012-06-25 Thread Don_X
Hello web2py users, I have made a quick sign up form using SQLFORM.factory, all the data entered on the various fields of the form are validating correctly, my error msgs are poping up the way I want ( and not into the form ) My SQLFORM.factory in the controller index file goes like this ( I

Re: [web2py] Short way to update or insert data from SQLFORM.factory into the main db.my_table ??? ...

2012-06-25 Thread Bruno Rocha
if form.process().accepted: db.auth_user.insert(**form.vars) response.flash = T('Quick Sign-up Accepted ! - Check your e-mail !') --