1. App Creation Studio
  2. Вопросы
+1
Отвечен

escaping single quotes

Michael Mikkelsen 12 лет назад • обновлен icahill (Administrator) 12 лет назад • 2
How do I escape the single quotes out of a text string so that I can put it into a SQL Database?
Michael Mikkelsen 12 лет назад
I added this function to functions.html. It works to escape the single quotes but I still have a problem if there are any double quotes in the string.


function dbText(str)
{
str = str.replaceAll("'", "&#39");
return str;
}
icahill (Administrator) 12 лет назад
This is the nature of XML, it does require XML encoding.

For double quotes you would have to use "

Сервис поддержки клиентов работает на платформе UserEcho