[web2py] a first py4web video tutorial - running on pythonanywhere.com

2019-09-22 Thread Massimo Di Pierro
https://youtu.be/Wxjl_vkLAEY -- 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] Re: py4web grid syntax - needs testers

2019-09-22 Thread isi_jca
Hi!!! In models.py, I have this table db.define_table('tempresa', Field('descripcion','string',length=50,label = T('Enterprise')), Field('email','string',length=50, label = T('Email')), Field('phone','string',length=50, label = T('Phone')), Field('estado','reference trestado',label =

Re: [web2py] Re: Unable to add auth.signature in table - PY4WEB

2019-09-22 Thread Massimo Di Pierro
Posted a new _scaffold. Now both db and auth are defined in common. If you import common from models, you are fine. On Sunday, 22 September 2019 17:48:53 UTC-7, Massimo Di Pierro wrote: > > The problem is that your code is executed before > > auth.enable() > > in common.py. The above

Re: [web2py] Re: Unable to add auth.signature in table - PY4WEB

2019-09-22 Thread Massimo Di Pierro
The problem is that your code is executed before auth.enable() in common.py. The above statement defines the auth_user table. I will refactor the scaffolding app to make sure common.py is imported before models.py -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Virtual machine for web2py with (Debian) Linux, Apache and Python 3.7

2019-09-22 Thread martel berends
I'm looking for a pre-build production like Virtual Machine with the complete infrastructure like Turnkey Linux. The Turnkey linux web2py appliance works on Python 2.7, and (or but) is working fine. Since Python 2 is officially end of life by the end of this year I would like to setup a new

[web2py] Web2Py Data POST Failure

2019-09-22 Thread Ben Mull
I am posting some dictionarty data to Web2py, Certain data POSTS consistently succeed, and certain data POSTS consistently fail. Both return , but the second data dictionary fails to post, with no error / exception raised. This data consistently succeeds to POST: data = {"batt chrg": {

Re: [web2py] Re: Problem with encoding (INSERT web2py)

2019-09-22 Thread Luciano Fain
I installed psycopg2 and all work fine now. Thanks anyway Massimo El dom., 22 sep. 2019 03:48, Massimo Di Pierro escribió: > ... and can you show us the complete traceback? > > On Saturday, 21 September 2019 23:47:28 UTC-7, Massimo Di Pierro wrote: >> >> Can you try? >> >> nombre_cliente =

Re: [web2py] Re: does having similar controller names or app folder names cause conflict in web2py?

2019-09-22 Thread Rahul Dhakate
Hi Massimo, I appreciate your reply. I had an application where in I had two controllers one called as default.py and the other called as default_0001.py in the same folder. I experienced strange issues which were fixed in the new default.py but were still there reflecting in the

[web2py] Re: Odd MySQL connection problem

2019-09-22 Thread backseat
Resolution, in case anyone else sees this: I had imported the database from our production system. The database includes a view. The database username, and thus the view creator name, are different on the production vs development system. That means the view is not visible to the MySQL user on

Re: [web2py] Re: Unable to add auth.signature in table - PY4WEB

2019-09-22 Thread sandeep patel
Now, I am getting another error. #model db.define_table('organization_info', Field('name'), Field('date_of_birth', 'date'), Field('village'), Field('block'), Field('district'), Field('state'), Field('country'), Field('pin'), auth.signature() ) On Sat, Sep 21, 2019 at 9:07 PM Massimo Di Pierro

Re: [web2py] Re: How can add new fields in the existing table in PY4WEB?

2019-09-22 Thread sandeep patel
Thank you for clarifying. On Sat, Sep 21, 2019 at 9:10 PM Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Yes and not. > > You can define your own auth_table before you call Auth() but you would > also need to modify the html and js logic that handle the ajax forms. > Maybe I will

Re: [web2py] Re: Does Database validators work in PY4WEB?

2019-09-22 Thread sandeep patel
Thanks Massimo, Now, it's working fine. On Sat, Sep 21, 2019 at 9:06 PM Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > They work the same as in web2py but you must import them > > from pydal.validators import * > > On Saturday, 21 September 2019 08:15:43 UTC-7, sandeep patel wrote:

[web2py] Re: Problem with encoding (INSERT web2py)

2019-09-22 Thread Massimo Di Pierro
... and can you show us the complete traceback? On Saturday, 21 September 2019 23:47:28 UTC-7, Massimo Di Pierro wrote: > > Can you try? > > nombre_cliente = u'SECRETARÍA' > > What is your connection string? which python version? > > On Saturday, 21 September 2019 23:43:42 UTC-7, Luciano Fain

[web2py] Re: Problem with encoding (INSERT web2py)

2019-09-22 Thread Massimo Di Pierro
Can you try? nombre_cliente = u'SECRETARÍA' What is your connection string? which python version? On Saturday, 21 September 2019 23:43:42 UTC-7, Luciano Fain wrote: > > Dear Team > > I have a string with an special charater on it: 'SECRETARÍA XXX' > > When i try to do an insert on DB > >

[web2py] Re: does having similar controller names or app folder names cause conflict in web2py?

2019-09-22 Thread Massimo Di Pierro
I do not see any problem with that On Saturday, 21 September 2019 01:09:36 UTC-7, Rahul wrote: > > > Hello All, >Will having a structure like below cause conflicts with web2py > controllers or applications ? I've found it does and when removed it > removes a few issues automatically. >

[web2py] Problem with encoding (INSERT web2py)

2019-09-22 Thread Luciano Fain
Dear Team I have a string with an special charater on it: 'SECRETARÍA XXX' When i try to do an insert on DB id_encabezado = db.encabezado.insert(tipo_reg = 0,nombre_cliente = 'SECRETARÍA' ) got the following error: 'ascii' codec can't decode byte 0xc3 in position 942: ordinal not in