[web2py] SQLFORM element(s) (delete or remove)

2018-10-11 Thread lucas
hello one and all, the API is tough to navigate. so, i'll ask. SQLFORM element and elements is very powerful. along with update, insert, and append. but how do you delete an element, or multiple elements, under an element that you found? thank you in advance, lucas -- Resources: -

Re: [web2py] Help needed with web2py-book app

2018-10-11 Thread Nico Zanferrari
Thank you Ben, I was looking at the same official page ;-) It seems that using the io module is the way to go, and it's already used in pymysql . I'm testing it. Nobody has suggestions about the session.foget() and session.flash message? thank you, nico Il giorno gio 11 ott 2018 alle ore

[web2py] Re: IS_IN_SET boolean force to SELECT

2018-10-11 Thread Ari Lion BR Sp
try to use represets Field('your_boolean_field', 'boolean', , represent = lambda your_boolean_field, row:SELECT( OPTION("YES",_selected=("selected"if your_boolean_field else "")),OPTION( "NO"))) Em quinta-feira, 11 de outubro de 2018 09:36:08 UTC-3, lucas escreveu: >

Re: [web2py] Help needed with web2py-book app

2018-10-11 Thread Ben Duncan
Also found this: http://python-future.org/compatible_idioms.html On Thu, Oct 11, 2018 at 10:30 AM Ben Duncan wrote: > Try These suggestions: > > > https://stackoverflow.com/questions/491921/unicode-utf-8-reading-and-writing-to-files-in-python/83 > http://www.evanjones.ca/python-utf8.html >

Re: [web2py] Help needed with web2py-book app

2018-10-11 Thread Ben Duncan
Try These suggestions: https://stackoverflow.com/questions/491921/unicode-utf-8-reading-and-writing-to-files-in-python/83 http://www.evanjones.ca/python-utf8.html On Thu, Oct 11, 2018 at 9:38 AM Nico Zanferrari wrote: > Hi, > > the encode-decode problem on question 1 is mostly related to

[web2py] Re: SQLFROM.grid sumarize option - totalization

2018-10-11 Thread Dan Carroll
I am also looking for a way to set a total in a parent (master) form from a sub-form (detail) coded in SQLFORM.grid. On Thursday, October 11, 2018 at 8:11:39 AM UTC-4, Ari Lion BR Sp wrote: > > Hi, > > a long time already I ask myself why SQLFROM.grid doesnt have a sumarize > option, mainly

[web2py] Using CRYPT()

2018-10-11 Thread Константин Комков
If I want to use CRYPT() for password, how users will be login? In book I read that: "By default, CRYPT uses random salt, such that each result is different." -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

Re: [web2py] Help needed with web2py-book app

2018-10-11 Thread Nico Zanferrari
Hi, the encode-decode problem on question 1 is mostly related to the opening of files. For example: filename = os.path.join(FOLDER, subfolder, 'chapters.txt') if PY2: lines = open(filename) else: lines = open(filename, encoding='utf-8') In PY2 there is no option for

Re: [web2py] Help needed with web2py-book app

2018-10-11 Thread Ben Duncan
Exactly what are you running into? I ran into this with my rewrite of of extract extract_pgsql_models.py: .. f['type'] = "'decimal({},{})'".format(f['precision'],f['scale']) had to become f['type'] = "'decimal({0},{1})'".format(f['precision'],f['scale']) And so one. The changes work

[web2py] IS_IN_SET boolean force to SELECT

2018-10-11 Thread lucas
hello one and all, i'm using 2.17.2. under the db DAL, i have a boolean field that defaults to a checkbox under SQLFORM.grid. how do i change that under Field to default to a SELECT instead of a INPUT(_type="checkbox")? thank you in advance, lucas -- Resources: - http://web2py.com -

[web2py] SQLFROM.grid sumarize option - totalization

2018-10-11 Thread Ari Lion BR Sp
Hi, a long time already I ask myself why SQLFROM.grid doesnt have a sumarize option, mainly bacause I use it very often to be the Detail part of a Master & Detail structure. I understand that the Grid is very often used as a long list (a very long list, and paginated), so somarize totals

[web2py] Re: BUG LOGIN WEB2PY WHEN USE ORACLE

2018-10-11 Thread 黄祥
think better to show error traceback or the related code, so that people in here can help best regards, stifan -- 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

[web2py] welcome app - broken menu on 2.17.2

2018-10-11 Thread Dragan Matic
welcome app's menu is broken on both firefox and chromium. This is how it looks on chromium: [image: chromium.png] And this is how it looks on firefox: [image: firefox.png] -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

[web2py] BUG LOGIN WEB2PY WHEN USE ORACLE

2018-10-11 Thread benito . pena
Hello guys, When i use Oracle database, Login method not working and return a error ilegal variable name (When i use Sqlite or MySQL everything is ok) Somebody help me Thanks -- Parque Empresarial Estrella del Sur Edificio Vilaser. C\ Aviación, 31  Oficina 1 · 41007 Sevilla  T: +34 955