[web2py] Changes to sqlhtml.py are not detected on linux server.

2021-05-25 Thread quesad...@gmail.com
Hi. I have modified the sqlhtml.py file. In my tests on windows, when restarting the web2py server, it works without problems. But when testing on the production linux server, even if I restart gninx or the full server, it doesn't catch those modifications. Any idea what may be going on? Sorry

Re: [web2py] Changes to sqlhtml.py are not detected on linux server.

2021-05-25 Thread Carlos Correia
Às 11:12 de 25/05/21, quesad...@gmail.com escreveu: Hi. I have modified the sqlhtml.py file. In my tests on windows, when restarting the web2py server, it works without problems. But when testing on the production linux server, even if I restart gninx or the full server, it doesn't catch those

Re: [web2py] DAL how to increment column value

2021-05-25 Thread Carlos Correia
Às 18:20 de 20/05/21, Rob Paire escreveu: Hello all, I am wondering if it's possible to use DAL update method to increment the value of table column H_REVNO in one line of code, and one trip to the database? I tried this query, and a couple of similar variations, but could not get it to work

Re: [web2py] DAL how to increment column value

2021-05-25 Thread Rob Paire
Hi All Thank you for the helpful comments! I am fine leaving the SQL Execute statement in place, but thought the question was worth asking. -Rob On Tuesday, May 25, 2021 at 8:06:46 AM UTC-4 Carlos Correia wrote: > Às 18:20 de 20/05/21, Rob Paire escreveu: > > Hello all, > > I am wondering if

Re: [web2py] DAL how to increment column value

2021-05-25 Thread valq...@gmail.com
db(...).update(some_field = db.some_table.some_field_or_another_field + 1) - should work ( it is a single db-query) вторник, 25 мая 2021 г. в 19:59:34 UTC+3, Rob Paire: > Hi All > Thank you for the helpful comments! I am fine leaving the SQL Execute > statement in place, but thought the quest

Re: [web2py] DAL how to increment column value

2021-05-25 Thread valq...@gmail.com
http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Expressions вторник, 25 мая 2021 г. в 22:36:47 UTC+3, valq...@gmail.com: > db(...).update(some_field = db.some_table.some_field_or_another_field + 1) > - should work ( it is a single db-query) > > > вторник, 25 мая

Re: [web2py] DAL how to increment column value

2021-05-25 Thread Rob Paire
Ah ha!!! Excellent - that looks so much better now! I appreciate your help -Rob On Tuesday, May 25, 2021 at 4:06:04 PM UTC-4 valq...@gmail.com wrote: > > http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Expressions > > вторник, 25 мая 2021 г. в 22:36:47 UTC+3, va