MS SQL and searchable=true

18 views
Skip to first unread message

Andrea Fae'

unread,
Aug 21, 2020, 5:38:54 AM8/21/20
to web2py-users
Using search standard widget with MS SQL server and trying to search only typing a string causes this error

for example when I search simply "202h719" it appears this

Query Not Supported: ('42000', u'[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Argument data type text is invalid for argument 1 of lower function. (8116) (SQLExecDirectW)')

if I search typing asset.nome = "202H719" it works.


Reply all
Reply to author
Forward
0 new messages