Sql query in uipath

Help
1

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
2

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

Cheers @vaish

3

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

4

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”,

5

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

6

Hi,

Thanks for the reply

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

7

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

8

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