[web2py] Connect to MSSQL with FreeTDS - [FreeTDS][SQL Server]Incorrect syntax near ';'. (102) (SQLExecDirect

2016-12-31 Thread Omicron VT
I an trying to connect to MSSQL DB. Cannot connect using this string : DB1 = DAL('mssql://user:pass@server/schema') so i have found this string to work: DB1 = DAL('mssql://user:pass@server/schema?DRIVER={FreeTDS}') but reading records from a table get me this error : [FreeTDS][SQL Server]Incorr

[web2py] websocket_messaging.py error on multiple connections

2017-01-23 Thread Omicron VT
Following the example in websocket_messaging.py i have this config: A tv.html view that refresh its content when an event on client.html sends a message to group1 All of this works fine if tv.html is opened only 1 time. When i open tv.html more than one time when first message is sended, tv.h

[web2py] SQLFORM.grid orderby by links

2016-02-17 Thread Omicron VT
In SQLFORM.grid is possible to order the results by a links field ? Example : links = [{'header':'ValueX2', 'body' : lambda row : row.value*2}] orderby = HERE IS WHERE MY QUESTION GOES grid = SQLFORM.grid(db.mydb , links=links,orderby=orderby) -- Resources: - http://web2py.com - http://web2py.c

[web2py] DAL query CONVERT field

2018-03-12 Thread Omicron VT
Is possible to create a query in DAL to obtain this ? SELECT * FROM table1 WHERE CONVERT(VARCHAR, field1) LIKE '%somestring%' where field1 is an INT type field ? Thanks in advance. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (So

[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) - https://code.google.com/p/web2py/i

[web2py] Pyfpdf - Split multicell from DB template

2017-06-15 Thread Omicron VT
Is it possible to use the split_multicell option to show a text field from a template stored in the DB ? Thanks. -- 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 Issue

[web2py] ERROR : ImportError: No module named gluon.utils in websocket_messaging.py after upgrade to 2.15.4

2017-11-01 Thread Omicron VT
I have been using websocket_messaging.py without problems in version 2.14.6. After upgrading to 2.15.4 i can not start websocket_messaging anymore, iget this error : ImportError: No module named gluon.utils Any help ? Thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documenta

[web2py] Re: ERROR : ImportError: No module named gluon.utils in websocket_messaging.py after upgrade to 2.15.4

2017-11-01 Thread Omicron VT
El miércoles, 1 de noviembre de 2017, 9:17:45 (UTC-3), Omicron VT escribió: > > I have been using websocket_messaging.py without problems in version > 2.14.6. After upgrading to 2.15.4 i can not start websocket_messaging > anymore, iget this error : > ImportError: No module na

[web2py] Re: websockets with web2py

2017-11-03 Thread Omicron VT
I think you have problem1 of this issue: https://github.com/web2py/web2py/issues/1696 El domingo, 25 de septiembre de 2016, 17:46:02 (UTC-3), José Borba escribió: > > Hello, there, > > I'm using web2py on Cloud9[1], and web2py works well. I'm working on an > app that need websockets, following a

[web2py] Re: ERROR : ImportError: No module named gluon.utils in websocket_messaging.py after upgrade to 2.15.4

2017-11-03 Thread Omicron VT
Answer to myself: Maybe solution to problem1 of this issue is the key : https://github.com/web2py/web2py/issues/1696 El miércoles, 1 de noviembre de 2017, 9:17:45 (UTC-3), Omicron VT escribió: > > I have been using websocket_messaging.py without problems in version > 2.14.6. After upg

[web2py] SQLFORM - update record, save datetime to table field

2018-02-02 Thread Omicron VT
I have a db table with a datetime field to save last update/creation date. Field('fecha_update', 'datetime', default=request.now) My question is : How i can save the update time of a record when i do it through sqlform.grid ? -- Resources: - http://web2py.com - http://web2py.com/book (Documen

[web2py] Include javascript file in layout.html

2019-05-29 Thread Omicron VT
I am trying to include Tabulator JS in layout.html but i can not make it work. If I include the files in the head section of view it works OK. But if I include them on the head section of layout.html and then in view i use extend 'layout.html' it can not find it. In sure is me, but i can not