XML Error while inserting Special Symbol like ' from dhtmlxG

Discontinued products Uncategorized discussions
#1

Hi,



I am using dynamic dhtmlxGrid, in which I am able to add/update row in database. but when I used ’ in string I got the below exception.



server response received java.sql.SQLException: ORA-00933: SQL command not properly ended

fallback to low level parsing



which is due to ’ symbol. I am using dhtmlx 2.0 version.



Is it any way to replace ’ into ‘’ before string sending to database to update.

#2

The problem is not related to grid’s functionality. Data correctly send to server side, but seems it break your data update code - most probably you forgot to escape data before using it in SQL query.

>>Is it any way to replace ’ into ‘’ before string sending to database to update.
Not possible on client side, but can be done in your server side code.