Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by Swapnil Deshmukh on Jan 11, 2009 23:38
open dhtmlx forum
XML Error while inserting Special Symbol like ' from dhtmlxGrid

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.
Answer posted by Support on Jan 12, 2009 02:37
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.