Sql query in uipath

Hi,

Am trying to pass the variable to SQL query as below.

variable is
decoded_text = “yurwertyu8745”

sql query is

“Select AES_DECRYPT(”+decoded_text+",keyvalue) FROM table_name"

showing error as you have error in sql syntax.

Please help

1 Like

Hi
Welcome to uipath community
try with this
“Select AES_DECRYPT(@decoded_text,keyvalue) FROM table_name"

Cheers @vaish

or like this even
“Select AES_DECRYPT(” & decoded_text & “,keyvalue) FROM table_name”

Kindly try this and let know for any queries or clarification
Cheers @vaish

Hi,

i tried with above solution,it is shows first one unknown column keyvalue, and second solution getting error as "
“message”: “Execute Query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ,keyvalue) FROM table_name’ at line 1”,

yah even i had that doubt
usually this is the syntax of a select statement
select columnname1, columnname2 from tablename
is this followed here
may i know what is the columnname here
Cheers @vaish

Hi,

Thanks for the reply

column name is variable which i am passing. that is decoded_text

This is the link am referring for encryption and decryption of the data.

did we try mentioning the columnname directly
is it working
the reason is to check whether that column is there in that table in database
Cheers @vaish