[web2py] Re: Databese error in registration process

2019-03-13 Thread Константин Комков
Leonel Câmara, Is that right? db.executesql("execute procedure esp_web_new_user('{0}','{1}','{2}','{3}','{4}',{5})".format(db._adapter. dialect.quote(str(form.vars.f)),db._adapter.dialect.quote(str(form.vars.i)), db._adapter.dialect.quote(str(form.vars.pser)),db._adapter.dialect.quote(str (form.va

[web2py] Re: Is it possible to sort the grid search fields list?

2019-03-13 Thread João Matos
That sorts the grid not the grid's search fields list. quarta-feira, 13 de Março de 2019 às 02:27:14 UTC, 黄祥 escreveu: > > is the sqlform.grid(sortable=True) doesnt meet your requirement ? > ref: > > http://web2py.com/books/default/chapter/29/07/forms-and-validators#SQLFORM-grid-signature > > bes

[web2py] Web2py online book page is returning an error

2019-03-13 Thread João Matos
Web2py online book page is returning an error Internal errorTicket issued: books/178.166.36.79.2019-03-13.09-10-57.75ae8466-170e-4585-92bb-608882e50879 -- Resources: - http://w

[web2py] Re: Databese error in registration process

2019-03-13 Thread Leonel Câmara
You don't need your own quotes now: "execute procedure esp_web_new_user({0},{1},{2},{3},{4},{5})".format(db._adapter.dialect.quote(str(form.vars.f)),db._adapter.dialect.quote(str(form.vars.i)),db._adapter.dialect.quote(str(form.vars.pser)),db._adapter.dialect.quote(str(form.vars.pnum)),db._adapte

[web2py] Re: web2py 2.18.4 is OUT

2019-03-13 Thread Leonel Câmara
I've sent a fix for the book, it was using a helper function from validators that's not imported right now. https://github.com/web2py/web2py-book/pull/417/files It's more a problem with the book app than the new web2py version. -- Resources: - http://web2py.com - http://web2py.com/book (Docume

[web2py] Re: Is it possible to sort the grid search fields list?

2019-03-13 Thread Leonel Câmara
No, not right now it isn't. What's possible is to make your own search_widget which could do the sorting of the search fields. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

[web2py] Re: Databese error in registration process

2019-03-13 Thread Константин Комков
What I need to do for user can be registered in database now without sql injections and errors? -- 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 recei

[web2py] Re: Mysql-Web2py connection failure

2019-03-13 Thread Leonel Câmara
That's a pymysql problem caused by MySQL changes. I would switch to MariaDB. Alternatively update your pymysql and see if it solves your problem I think they fixed it. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - h

[web2py] Re: Is it possible to sort the grid search fields list?

2019-03-13 Thread João Matos
:( Not even make it show the fields in the same order they are in the grid's fields argument? quarta-feira, 13 de Março de 2019 às 10:16:11 UTC, Leonel Câmara escreveu: > > No, not right now it isn't. What's possible is to make your own > search_widget which could do the sorting of the search f

[web2py] Uh Oh ... web2py.com error..

2019-03-13 Thread Ben Duncan
http://web2py.com/books/default/chapter/29/05?search=data Internal errorTicket issued: books/205.144.224.2.2019-03-13.11-52-48.afb41d97-713c-4ce6-b3b3-f4329ec13e2e Must be using 2.

[web2py] Re: Uh Oh ... web2py.com error..

2019-03-13 Thread Ari Lion BR Sp
Me too - please help Em quarta-feira, 13 de março de 2019 08:56:17 UTC-3, Ben Duncan escreveu: > > http://web2py.com/books/default/chapter/29/05?search=data > Internal errorTicket issued: > books/205.144.224.2.2019-03-13.11-52-48.afb41d97-713c-4ce6-b3b3-f4329ec13e2e >

[web2py] Linking GRID records with other records in same GRID

2019-03-13 Thread Sarbjit
I am using SQLFORM.GRID to display the database records. In my application, certain records may contain the reference to id of other records. Currently, I have to use "search" option to find the record matching reference id. What I want to do is :- Have a hyperlink in the reference field and th

[web2py] Re: Big picture issues in using react with web2py

2019-03-13 Thread Ian W. Scott
Thanks Anthony. That's very helpful. On Monday, March 11, 2019 at 7:02:31 PM UTC-4, Anthony wrote: > > On Monday, March 11, 2019 at 9:52:16 AM UTC-4, Ian W. Scott wrote: >> >> I'd like to use react to build a relatively freestanding, single-page >> front-end interface that communicates with web2p

[web2py] How can I call the delete confirmation dialog from the grid's selectable buttons?

2019-03-13 Thread João Matos
Hello, How can I call the delete confirmation dialog from one of the grid's selectable buttons? Thanks, JM -- 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)

[web2py] Web2py binaries

2019-03-13 Thread Nico Zanferrari
Hi, I've just updated the experimental Windows binary version with python 3.7.2 to web2py 2.18.4 . Also, now there is in addition the no_console binary and there is the python-ldap module included. Grab it from https://github.com/nicozanf/web2py-pyinstaller : please test it and give me a feedback.