Re: Flow not working when I used variables in the SQL query (265 Views)
Reply
Frequent Advisor
Posts: 127
Registered: ‎12-17-2012
Message 1 of 2 (285 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...

 

 

 

 

Highlighted
Frequent Advisor
Posts: 47
Registered: ‎06-17-2011
Message 2 of 2 (265 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
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.