postgres keywords in .net framework editor
postgres keywords in .net framework editor
as per https://datatables.net/forums/discussion/61563 but for .net framework
using postgres11
editor 2.02
latest datatables
.net 4.6.1
A table with the columname keyword "desc" is not being escaped properly and fails
Debuginfo query generated by editor-server
"SELECT id as \"id\", the_geom as \"the_geom\", desc as \"desc\" FROM public.testdesc_1 ORDER BY id asc LIMIT 40 OFFSET 0"
Console error
Uncaught Error: DataTables warning: table id=tabEditDataset - ERROR: 42601: syntax error at or near "desc"
at _fnLog (jquery.dataTables.js:6530)
at Object.success (jquery.dataTables.js:3934)
at fire (sm.min.js:3)
at Object.fireWith [as resolveWith] (sm.min.js:3)
at done (sm.min.js:3)
at XMLHttpRequest.callback (sm.min.js:3)
Has the above fix for PHP postgres been applied to the .net framework version, I noticed on the https://editor.datatables.net/generator that all seems to be fine
Please assist if possible
This question has an accepted answers - jump to answer
Answers
Apologies no, that fix didn't make it over to the .NET libraries. I've just made that change now and like in the other post our unit tests will run on it soon.
Are you happy building a new dll from that repo, or I can send you one over if you prefer?
Allan
Hi Allan,
Sorry for the delay in feedback,
I will download the package when it has made it to the full release.
Thanks for fixing