Postgresql Datatable search
Postgresql Datatable search
Gerald.Rager
Posts: 19Questions: 3Answers: 0
in Editor
Hello,
if i search in the datable search field (i search the id of a database row)
i got this failure
DataTables warning: table id=customer - SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: integer ~~ unknown
LINE 1: SELECT COUNT(id) as cnt FROM test WHERE (id like $1 )
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
thanks for any help
This discussion has been closed.