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

 

 

 

 

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