Sql query in uipath


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

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


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


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