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, whi…

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 +“) a…

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

Hi @vidyasak Please check this tutorial [image] How To Pass Dynamic Data To SQL Query From UiPath? Knowledge Base 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 Pass…

@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

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 (”+s…

How to pass string value as parameter in sql squer?

Help Studio

fernando_zuluaga (Fernando Zuluaga) April 13, 2023, 8:45pm 3

Hi @vidyasak

Please check this tutorial

Regards

Topic		Replies	Views
String format error Studio studio , question , activities_panel	8	2480	January 26, 2024
Passing String as Parameter in SQL Query Help	14	14693	March 31, 2020
How to pass the dynamic value in SQL from uipath StudioX	9	1651	March 15, 2023
Using Variables in a SQL Query - String Commands must end in Double Quotes Studio datatable , studio , question , sql , activities_panel , variables_management , sql-stored-procedure , fetch-sql-data	10	4095	April 14, 2022
How can pass Studio studio , question , designer_canvas	13	1728	February 15, 2022

How to pass string value as parameter in sql squer?

Related topics