[web2py] Failing to get any response from the controller shell

2016-07-04 Thread Gualter Portella
Dear all, I am experimenting with web2py and, after designing a table and populating it with a csv file, went to the controller shell to query a little, but I just got the message: None. I tried to connect the database, but nothing works. What am I doing wrong? Can anyone help? Thanks in advan

[web2py] Making two queries into one

2016-11-05 Thread Gualter Portella
Dear all, I hope this e-mail finds you all well. I have written two queries to retrieve data from my database (model). I did them initially through plain SQL, then I followed the DAL syntax. They all return the same output regardless the syntax chosen. Please, see the code below: Two differen

Re: [web2py] Re: Making two queries into one

2016-11-06 Thread Gualter Portella
re specifically, indicadores_id and elementos_id). > Without that, there's - apparently - no way to link eleban and indiban. > >> On Saturday, November 5, 2016 at 3:16:10 PM UTC+1, Gualter Portella wrote: >> Dear all, >> >> I hope this e-mail finds you all well.

Re: [web2py] Re: scheduler creates "zombie" processes

2016-11-06 Thread Gualter Portella
t (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, v

Re: [web2py] Re: ECMAScript Modules Vue and Web2py - simple test

2018-03-24 Thread Gualter Portella
Thank you for the initiative! I am looking forward to learning vue.js and using it together with web2py. One minor problem is that I am not still getting the message Into the index page correctly. It only comes in the form of ${message}. What I might be doing wrong? Cheers -- Resources: - http

[web2py] Re: ECMAScript Modules Vue and Web2py - simple test

2018-03-24 Thread Gualter Portella
Thanks, Marco. It was just a browser support issue with firefox. Em sexta-feira, 23 de março de 2018 16:07:26 UTC-3, marco mansilla escreveu: > > Just in case anyone is interested I have uploaded a simple test app with > VueJS as modules in the browser. > > Did it to test and see how it works,

[web2py] Controller to Ajax Function AND View

2018-05-17 Thread Gualter Portella
Hi everyone, I currently have a function in the default.py controller like the one below: def overview(): some code goes here return dict(income=json(income), form=form, bank=bank) The first variable is passed to the javascript tag in order to render a chart trough Chart.js The

Re: [web2py] Re: Controller to Ajax Function AND View

2018-05-18 Thread Gualter Portella
[some code] > if request.ajax: > return response.json(income) > [more code] > return dict(income=json(income), form=form, bank=bank) > > Anthony > >> On Thursday, May 17, 2018 at 2:52:58 PM UTC-4, Gualter Portella wrote: >> Hi everyone, >> >&

[web2py] Updated script for 'Moving your data from one database to another' recipe

2018-07-21 Thread Gualter Portella
Hi everyone, I've been trying to move my sqlite database to a nysql database for production. I've been trying the recipe, but get only two responses: 1) when I type the following command on the command line : (User) C:\Users\Lenovo\Documents\git>python web2py.py -S site -M -N -R applications\

Re: [web2py] Re: Updated script for 'Moving your data from one database to another' recipe

2018-07-22 Thread Gualter Portella
e-use an existing field in other > tables -- you must instead clone it. > > Anthony > > > On Saturday, July 21, 2018 at 6:26:33 PM UTC-4, Gualter Portella wrote: >> >> Hi everyone, >> >> I've been trying to move my sqlite database to a nysql database for &g

[web2py] Sendin mail

2018-08-18 Thread Gualter Portella
Hi, everyone. I am struggling to make this form send messages from users input. My code is below: default.py: form = FORM(INPUT(_name='name', _placeholder=T('Name'), _class="form-control", _style="margin-bottom: 10px;", requires=IS_NOT_EMPTY()), INPUT(

Re: [web2py] Re: Sendin mail

2018-08-19 Thread Gualter Portella
Hi, Stifan. Thanks. No trace back at all. Just the message from the controller. Enviado do meu iPhone Em 18 de ago de 2018, à(s) 21:45, 黄祥 escreveu: > is there any error traceback ? or what is it said on terminal or web2py log? > perhaps you can start from simple first by following the example

[web2py] changing %(link)s

2018-08-19 Thread Gualter Portella
Hi, Can anybody provide me with specfic directions on how to do the following procedure: In Auth, by default, email verification is disabled. To enable email, append the following lines in the model where auth is defined: 1 2 3 4 5 auth.settings.registration_requires_verification = Trueauth.

Re: [web2py] Re: changing %(link)s

2018-08-20 Thread Gualter Portella
e link > https://yourdomain.com/user/verify_email to verify your email' > > Anthony > > > On Sunday, August 19, 2018 at 10:30:07 PM UTC-4, Gualter Portella wrote: >> >> Hi, >> >> Can anybody provide me with specfic directions on how to do the following >> p

Re: [web2py] Re: changing %(link)s

2018-08-20 Thread Gualter Portella
ord' > > Anthony > > On Monday, August 20, 2018 at 11:12:29 AM UTC-4, Gualter Portella wrote: >> >> Thanks, Anthony! >> >> And what about the auth.messages.reset_password? It needs the hashcode to >> redirect to the specfic user, right? >> >>

[web2py] Web2py website list

2018-09-02 Thread Gualter Portella
Hi everyone, I would like to thank this great community for supporting the amazing Web2py framework! About a year ago I was barely able to write a few lines of python code and now I have finished my webapp dedicated to financial information from Brazilian financial system! If you think the app d

[web2py] Creating table on the fly with the app in production

2019-03-08 Thread Gualter Portella
Hi everyone, My app is in production and is hosted at RoseHosting. I will soon need to create several tables and want to avoid those “auth.user table has already been created” messages when the app crashes as I insert new code on, for example, db.py. I will insert code like this, simple stuff: db

Re: [web2py] Re: Creating table on the fly with the app in production

2019-03-08 Thread Gualter Portella
Thanks, Leonel! I will try it out tomorrow. Cheers Enviado do meu iPhone Em 8 de mar de 2019, à(s) 19:58, Leonel Câmara escreveu: > The simple stuff you talk about should simply work: > > 0. backup the database, this is just good practice... > 1. if you're running the scheduler you should s

[web2py] Rendering SVG files

2017-07-02 Thread Gualter Portella
Hi everyone, I am formatting the landing page of my app and found that the svg files have not been rendered. So far I have converted all of them into png, jpg etc, but some got really ugly. Do you know of any workarounds so that I can render the actual svg files with web2py? Many thanks. -- R

[web2py] Re: Rendering SVG files

2017-07-03 Thread Gualter Portella
; Em domingo, 2 de julho de 2017 20:34:51 UTC-3, Gualter Portella escreveu: >> >> Hi everyone, >> I am formatting the landing page of my app and found that the svg files >> have not been rendered. So far I have converted all of them into png, jpg >> etc, but some got r

[web2py] Re: warning for postgres users: current contrib/pg8000 is old and causes weird postgres errors

2017-08-22 Thread Gualter Portella
Alex, You've got to upgrade your account to a paid one on the account tab. When you customize your plan, choose the postgres server option. The postgres option itself will cost you an extra charge of US$7 per month. Hope this helps. Gualter Em segunda-feira, 21 de agosto de 2017 14:07:30 UTC-

Re: [web2py] Re: warning for postgres users: current contrib/pg8000 is old and causes weird postgres errors

2017-08-22 Thread Gualter Portella
Hi Alex, What I did a month ago was to click on the update button and it worked. Best, Gualter Enviado do meu iPhone > Em 22 de ago de 2017, às 13:33, Alex Glaros escreveu: > > Thanks Gualter. I do have the paid account but web2py versions are not > automatically updated on pythonAnywhere, so

Re: [web2py] Re: warning for postgres users: current contrib/pg8000 is old and causes weird postgres errors

2017-08-23 Thread Gualter Portella
To be honest I did not check, but you can check using the shell. Best, Gualter Enviado do meu iPhone > Em 22 de ago de 2017, às 21:52, Alex Glaros escreveu: > > did it update pg8000 too? > > thanks Gualter > > Alex > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Document

[web2py] Formatting numbers in view

2017-10-30 Thread Gualter Portella
Dear all, I have been trying to reformat the numbers retrieved from the DB into the format used in my country (Brazil). I want to change decimals to ',' and thousands to '.' The thing is that the only solution that I can figure out is in Python 3 - I am am new to programming and webdev, like t

Re: [web2py] Re: Formatting numbers in view

2017-10-30 Thread Gualter Portella
ion > API. > > > > Il giorno lunedì 30 ottobre 2017 18:59:27 UTC+1, Gualter Portella ha > scritto: >> >> Dear all, >> >> I have been trying to reformat the numbers retrieved from the DB into the >> format used in my country (Brazil). >> >> I w

[web2py] ChartistJS in web2py

2017-12-21 Thread Gualter Portella
Dear all, I am developing an app which contains charts and a dashboard. I am experimenting with ChartistJS and tried to replicate the first example of its website in web2py. in layout.html, I added: ... in default/index.html, I added: {{extend

[web2py] Re: ChartistJS in web2py

2017-12-21 Thread Gualter Portella
Ok, Stifan. I will try this out and let you know. Thanks. -- 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

[web2py] Re: ChartistJS in web2py

2017-12-22 Thread Gualter Portella
Dear Stifan, thanks again. It worked. Just had to add in the index.html file: {{block head}} {{end}} Cheers Em quinta-feira, 21 de dezembro de 2017 19:18:49 UTC-2, 黄祥 escreveu: > > had you inspect it (chrome)? is it loaded in console tab in the browser > inspection ? > usually not put it (ch

[web2py] Tutorial on using chart library

2018-01-23 Thread Gualter Portella
Hi everyone, I am looking for a tutorial in web2py that shows how to create dynamic graphs - fetching data from the database and passing them to the JS library through ajax or something similar. Does anyone know of any? Thanks. Gualter -- Resources: - http://web2py.com - http://web2py.com/bo

Re: [web2py] Tutorial on using chart library

2018-01-23 Thread Gualter Portella
Thanks, António! -- 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"