This may be confusing but I am hoping someone can help. So I am trying to pass a string variable into an SQL query but I believe the quotes are messing it up. For example: When I don’t use a parameter and I just pass in the values (‘dog’),(‘cat’) it works fine. But when I build that same string int…

@jpreziuso , Set Parameters (as strings) in the relevant collection argument. Make sure that names match of course.

I do have the parameter set as a string

what do you mean when i pass the valueS, is it a string or not? cause if it is string then you have to pass one value…

I am trying to pass in values to a SQL column. So when I pass them in individually like (‘dog’),(‘cat’) it works fine. But when I build a string “(‘dog’),(‘cat’)” and store it as the parameter AnimalString to be passed into the query…the double quotes (from it being a String datatype instead of just…

this string looks wrong… what are those ( and )… also those apostrophes should be escaped with one more in each…

The parentheses and apostrophes are required since this is being used in a SQL query. That is the SQL syntax The string I build to pass in as a parameter prints out exactly how I want it to look. The issue comes because it is being passed in as a string, so double quotes are placed around it which …

[image] jpreziuso: “(‘dog’),(‘cat’)” just send like this: "(''dog''),(''ca'')"

That does not seem to help. When I give include (‘dog’),(‘cat’) in the SQL query, it works fine. But when I attempt to assign that same string to a variable and pass it in as a parameter, it causes an issue. Does that help to explain?

not really… do you have a string column in your database and you want to have values like (‘dog’),(‘cat’) right? if you have a sql procedure to insert them and one of your variables should take a string with that, then what is the result inside that column?

Yes I want to add those values to the column of a temp table and then complete a join with that temp table and another table. The result of the join is skewed because of the quotes. I know it is confusing though. Thank you for your help

Passing String as Parameter in SQL Query

Help

bcorrea (Bruno Correa) January 27, 2020, 5:40pm 8

just send like this: "(''dog''),(''ca'')"

Inserting Rows into SQL Table

Topic		Replies	Views
How to pass string value as parameter in sql squer? Studio studio , question , workflow_diff	5	1583	April 14, 2023
How can pass Studio studio , question , designer_canvas	13	1721	February 15, 2022
Inserting Rows into SQL Table Help	6	3437	January 28, 2020
String format error Studio studio , question , activities_panel	8	2453	January 26, 2024
SQL String Parameter Issues Help studio , question	9	2414	December 14, 2020

Passing String as Parameter in SQL Query

Related topics