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 > > > 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(

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 : > db.auth_user.insert(**db.auth_user.em

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 brake

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 ... > > Field email_check do

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 ... 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 just a verification scheme !

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 !') --

[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 hav