Flow not working when I used variables in the SQL query (114 Views)
Reply
Frequent Advisor
vshivanna
Posts: 108
Registered: ‎12-17-2012
Message 1 of 2 (114 Views)

Flow not working when I used variables in the SQL query

Hi,

 

I am trying to get the data from DB using select query... But when I used variables like ${username} or some variables in the query, the flow is not working....

 

This is the query I used:

 

 

Select status from software where username=${username} and applicationname =${appname} and machinename = ${machinename}

 

When I used like this,

Select status from software where username=vinay and applicationname =adobe and machinename = testmachine..

It is working...

 

 

 

 

Please use plain text.
Frequent Advisor
jarodb
Posts: 43
Registered: ‎06-17-2011
Message 2 of 2 (94 Views)

Re: Flow not working when I used variables in the SQL query

Surround your variables with single quotes

 

Select status from software where username='${username}' and applicationname ='${appname}' and machinename = '${machinename}'

 

 

//Actively seeking HPOO opportunities
Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation