How to pass string value as parameter in sql squer?

[vidyasak (Sagar)]

I am trying to pass a string value to sql query dynamically:

The query is :-

“SELECT distinct user_name,site_name,manager_1,manager_2,description
FROM xxxinternal.xxxtable
where back_group in (”+spList+“)
and main_group in (‘Delhi’,‘Mumbai’,‘Kolkata’)”

and the value for spList is as below, which is an output of another query:-

‘Hyderabad’,‘Pune’,‘Bangalore’

Getting an syntax error as : “String constants must end with double quotes”. Looking for a breakthrough.

[ZoranK (Zoran)]

instead of
”+spList+“
try
“+Chr(34)+spList+Chr(34)+”

[fernando_zuluaga]

Hi @vidyasak

Please check this tutorial

How To Pass Dynamic Data To SQL Query From UiPath?

How to pass dynamic data to SQL query from UiPath ? Pass dynamic data to SQL query, by following any of the below methods Passing variable to SQL query Passing parameter to SQL query Approach #1: Passing Variable To SQL Query In order to pass variables to SQL query, variables must be declared first. In the below screenshot, three variables are declared and assigned values using assign activity before doing any SQL operation. [1.png] The SQL query(INSERT/UPDATE/SELECT) needs to be modified t…

Regards

[Anil_G (Anil Gorthi)]

@vidyasak

Can you please try printing thw query in log message and check…there might be an extra double quote or a missing one…alternately might be the case that it is expecting double quotes in place of single

Also for ease try enclosing table between square brackets

Cheers

[vidyasak (Sagar)]

Hi Anil,
I used the same approach with ”+spList+“ and it was successful.
The trick here is the query should be in a single line without a new line , if we are using parameters.

“SELECT distinct user_name,site_name,manager_1,manager_2,description FROM xxxinternal.xxxtable where back_group in (”+spList +“) and main_group in ‘Delhi’,‘Mumbai’,‘Kolkata’)”

[vidyasak (Sagar)]

I used the same approach with ”+spList+“ and it was successful.
The trick here is the query should be in a single line without a new line , if we are using parameters.

“SELECT distinct user_name,site_name,manager_1,manager_2,description FROM xxxinternal.xxxtable where back_group in (”+spList +“) and main_group in ‘Delhi’,‘Mumbai’,‘Kolkata’)”