Home > Forum > Actions > Why SQL query is changing single quote to double quote?

Why SQL query is changing single quote to double quote?
1

Hello,
Does anyone can help me, why in WEBCON SQL query apostrophe is replace with quotation mark?
On the form, I have an attribute with value: '2339226', '2504286'.
In action "Change items lists value", I used an SQL query whith this attribute, but query preview returned "2339226", "2504286".

Regards

MVP

Hello,
it's not an apostrophe - it's double single quote mark.

You are using text field, so Webcon is escaping the single quotation mark by adding second one.
Single quotation mark is reserverd character in SQL, so putting 2 of them let's SQL Server know it should be part of the string.

I'd try removing those quotes from text field if possible, and inside sql query use dbo.SplitToTable with comma as separator and text without quotes as input.