19.10.2022
15:37
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
20.10.2022
08:48
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.
20.10.2022
09:10
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.
Problem with using dbo.SplitToTable is when you try use query in two different connection: outside query from oracle but inside you can't use dbo.SplitToTable becouse this function is from default/mssql connection
