[web2py] Re: Changing color of a cell function of another cell value

2018-11-26 Thread Yann Dulondel
Le mercredi 21 novembre 2018 10:51:16 UTC+1, Yann Dulondel a écrit : > > Hi all, > I have a container number and a function that check the number is valid. > The result of the function is store in field cntnumok (boolean). > I found that we can change the color with "represent" and found an examp

[web2py] Re: Changing color of a cell function of another cell value

2018-11-26 Thread Yann Dulondel
Val K You are right this work db.articles.conteneur.represent = lambda v, row: SPAN(v,_class='cnt-false' if row.cntnumok==False else None) I was believing this was refering to the database row , but in fact this refere to the result of select command in which i had not included the cntnumok fie

Re: [web2py] Re: Migrations

2018-11-26 Thread Ben Duncan
Thanks Dave !!! That makes sense. I tried a few tables with "fake migration" (for grins and giggles) turned on and the code that generates the database/ stuff choked and puked all over the "foreign keys". I went back and left it as is, with everything expected as a "external" table, whcih is jus

Re: [web2py] Re: Hierarchy (BOM) using closure table with triggers in DAL?

2018-11-26 Thread Ben Duncan
What database are you using ? In our e-file system, we have something similar with court cases, but we use db functions to do the heavy lifting for use, since in postgres they can be called with a select directly ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court El

Re: [web2py] Re: Hierarchy (BOM) using closure table with triggers in DAL?

2018-11-26 Thread Val K
It is sqlite3 example and it also uses db function... I do not quite understand what confuses you On Monday, November 26, 2018 at 3:47:29 PM UTC+3, Ben Duncan wrote: > > What database are you using ? > > In our e-file system, we have something similar with court cases, but we > use db functions

[web2py] Re: Is it possible to share cache between two differente web2py applications?

2018-11-26 Thread Lisandro
Thanks Massimo! I've recently noted that the fix I did was incomplete. I've sent a new pull request with the new code: https://github.com/web2py/web2py/pull/2059 Regards, Lisandro. El domingo, 18 de noviembre de 2018, 16:06:37 (UTC-3), Massimo Di Pierro escribió: > > approved! :-) > > On Wednes

[web2py] Re: Delete space from users email in auth form

2018-11-26 Thread Константин Комков
Today I tried both of variant: first in default.py def user(): if request.vars.email: request.vars.email = request.vars.email.lower().strip() return dict(form=auth()) don't work - "incorrect email" second, I don't sure that all right here in db.py def emailStrip(): form.vars.

[web2py] Pythonanywhere Configuration Help

2018-11-26 Thread Adonis
Hi, At one point I had my web2py code on pythonanywhere and everything was fine. Eventually my domain expired and I deleted the web2py app. The code was saved and accessible in the web2py directory. When i created a new app, I had to change the directory to something else because pythonanywher

[web2py] Re: Pythonanywhere Configuration Help

2018-11-26 Thread 黄祥
the error message show that the directory is not empty, perhaps you can backup the app, delete web2py and recreate web2py (start from scratch) then restore the app *e.g. backup application in pythonanywhere console* mkdir -p ~/appdata/webapp rsync -zhavur ~/web2py/applications/* ~/appdata/webapp/

[web2py] Re: Delete space from users email in auth form

2018-11-26 Thread Val K
1. Oops, instead of request.vars it should be request.post_vars 2. As 1st validator try CLEANUP('\s') -- 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: Delete space from users email in auth form

2018-11-26 Thread Константин Комков
Yes, it's work: def user(): if request.post_vars.email: request.post_vars.email = request.post_vars.email.strip() return dict(form=auth()) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.go