Use variables in SQL querie

Hey,
i try to use my variable strInputEmail in my SQL query.

UiPath told me now that i have a syntax error and I dont know why…

My query is
“Select UserID From User WHERE Mail = @strInputEmail

Every column is correct and the variable name also…

What is the correct syntax to user variables in my queries?

Thanks for your help:-)

1 Like

Use “+” to use variable in a string say
"My name is "+Var_Name
For strInputEmail this var
“Select UserID From User WHERE Mail = "+strInputEmail

@Ashtari

You can pass the variable by using parameters

Hope this helps

Thanks

Hi @Ashtari

“select * from User”

“select UserID from User WHERE Mail = '”+strInputEmail+"’"

Hope this would solve your issue :slight_smile:
Mark as solution and like it.

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer: