[web2py] Re: Databese error in registration process

Uh, I found reason of error it was small length field for name in procedure. Length name that user was 25 chars! I want to ask, have that code issue for SQL injections now or not? db.executesql( "execute procedure esp_web_new_user('{0}','{1}','{2}','{3}','{4}',{5})". format( str(form.vars.f),str

[web2py] Re: Databese error in registration process

Yes that has a sql injection vulnerability this doesn't: "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(fo

[web2py] Re: Databese error in registration process

Thank you, Leonel Câmara! -- 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 "web2

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

I found a solution. I bit "insane", but it works. I post it here so that it can help others. In the function responsible for the the grid's selectable button action I redirect to itself with the grid selection as a request.var. redirect(URL(vars={'id': ids[0]}, user_signature=True)) Then on th

[web2py] Re: Databese error in registration process

I have doubt need I use: db.executesql() or not becouse I see you don't use it twice? Without db.executesql() I don't have error but could not be registrated. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://cod

[web2py] Is it possible to have dummy columns in a grid without seeing them in the search field selection?

Hello, Is it possible to have dummy columns in a grid without seeing them in the search field selection? Something like this (see the fields and headers arguments): grid = SQLFORM.grid( (db.wo.pies_verified == False) & (db.wo.is_active == True), _class='web2py_grid_list_tags

[web2py] Re: Databese error in registration process

You do need to use executesql to run the procedure, I just wanted to show you how to build a string for it so I left that out. -- 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: Is it possible to have dummy columns in a grid without seeing them in the search field selection?

Make the fields you don't want to have on the search have searchable=False instead of readable=False -- 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

[web2py] Re: Is it possible to have dummy columns in a grid without seeing them in the search field selection?

That worked. Thanks. quinta-feira, 14 de Março de 2019 às 17:06:05 UTC, Leonel Câmara escreveu: > > Make the fields you don't want to have on the search have searchable=False > instead of readable=False > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github

[web2py] Is it possible to make a form field depend on another form field without submiting the form?

Hello, Is it possible to make a form field depend on another form field without submiting the form? 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 Issu

[web2py] Re: Is it possible to make a form field depend on another form field without submiting the form?

Sort of, you can use show_if http://web2py.com/books/default/chapter/29/07/forms-and-validators#Conditional-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 (Report Iss

[web2py] Re: request.requires_https() Python 3 bug

can you please try 2.18.4? On Monday, 11 March 2019 18:16:25 UTC-7, Yi Liu wrote: > > I think this is a python 3 bug: > > I have > > request.requires_https() > > in a model file 1_server.py > > Then after I switch to Py3 recently, I start to collect these errors: > > Ticket ID > > 221.2.44.75.201

Re: [web2py] Re: Poweredby error

I will look into this asap. On Monday, 11 March 2019 05:15:57 UTC-7, Daniel Guilhermino wrote: > > Hi Kevin Keller, > > *I apologize, I believe I didn't express myself correctly.* > > *I tried to submit the application on the official web2py website, to be > part of the list "applications made wi

Re: [web2py] Re: Error: Exporting CSV file in SQLFORM.grid

Thanks! On Tuesday, 12 March 2019 22:52:31 UTC-7, sandeep patel wrote: > > I have solved this problem. This problem is occurring because of filter > object you have to convert into the list. > You have to need some changes in the sqlhtml file. > go to gluon/sqlhtml.py change line no : 2688 > > F

[web2py] Re: Web2py online book page is returning an error

which page? On Wednesday, 13 March 2019 02:12:32 UTC-7, João Matos wrote: > > 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 >

[web2py] Re: Web2py binaries

The official version is currently broken. On Wednesday, 13 March 2019 15:53:09 UTC-7, Nico Zanferrari wrote: > > 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

[web2py] Re: web2py 2.18.4 is OUT

I think I saved error in my app and after that I have error in web2py. invalid syntax (, line 14)Версия web2py™ Version 2.18.4-stable+timestamp.2019.03.13.05.27.54 Python Python 2.7.10: C:\Python27\python.exe (prefix: C:\Python27)Traceback 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. T