[web2py] Re: Help with an error:

2018-08-14 Thread Anthony
What is your model definition? Is "valor" a numeric field? On Tuesday, August 14, 2018 at 8:13:44 PM UTC-4, Morganti wrote: > > Hi guys, > > I am having the error below: > > Número do Ticket > > 187.122.40.48.2018-08-14.20-50-49.b4d5d6f0-071d-4f6b-aec3-1c662eb5ea0c > function sum(character

[web2py] Help with an error:

2018-08-14 Thread Morganti
Hi guys, I am having the error below: Número do Ticket 187.122.40.48.2018-08-14.20-50-49.b4d5d6f0-071d-4f6b-aec3-1c662eb5ea0c function sum(character varying) does not exist LINE 1: SELECT SUM("ov_home"."valor") FROM "ov_home" WHERE ((("ov_ho... ^ HINT: No function matches the given name and

[web2py] Can start cron in 2.17.1

2018-08-14 Thread Omicron VT
Trying to start the cron with -Y option gives me an error: " TypeError: argument of type 'NoneType' is not iterable " Any ideas. Thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Search for list:string values in grid search?

2018-08-14 Thread Marcelo Huerta
Is it possible at all to search for values contained in fields defined as list:string in the grid search dialog? -- 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

Re: [web2py] Re: Python3 and gluon/xmlrpc.py

2018-08-14 Thread Johann Spies
Thanks Leonel. -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3) -- 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: Python3 and gluon/xmlrpc.py

2018-08-14 Thread Leonel Câmara
It's a bug. The fix could be something like: from gluon._compat import PY2 if PY2: from SimpleXMLRPCServer import SimpleXMLRPCDispatcher else: from xmlrpc.server import SimpleXMLRPCDispatcher -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Python3 and gluon/xmlrpc.py

2018-08-14 Thread Johann Spies
On Debian I have: apt-file search /usr/lib/python2.7/SimpleXMLRPCServer.py libpython2.7-stdlib: /usr/lib/python2.7/SimpleXMLRPCServer.py But there is no such file for python3. Therefore this line(10) fails on python3: from SimpleXMLRPCServer import SimpleXMLRPCDispatcher I suspect this is a

[web2py] groupby count/sum on grid

2018-08-14 Thread JSalvat
Hi, How can this be done using SQLFORM.grid ? def groupgrid(): cant = db.emitida.id.count() suma = db.emitida.total.sum() rows = db(db.emitida.numero.startswith('18')).select(db.emitida.empresa, cant, suma, orderby=db.emitida.empresa, groupby=db.emitida.empresa) head =