Forum Discussion

baba_k's avatar
baba_k
Occasional Contributor
14 years ago

Unable to pass the variables in SQL query through test complete script

Hi, Can anyone please explain how to pass variables into SQL query through script: Below is the syntax that we are using and getting an error: Qry.SQL = "Select * from Aq1lookupalarapart whe...
raluca_suditu's avatar
raluca_suditu
Contributor
13 years ago
Hello again,

I found the solution in the help files and I did like this:

function



GetLastDatabase()


{


  var Qry;


// Create a query


  Qry =


ADO["CreateADOQuery"]();


// Specify the connection string


  Qry["ConnectionString"] = "Driver={SQL Server};Server=xxx;Uid=xxx;Pwd=xxx";


// Specify the SQL expression


  Qry["SQL"] = "select name from sys.databases where name like :Database_Name";


// Execute the query


// Specify the parameter value


  Qry["Parameters"]["ParamByName"]("Database_Name")["Value"] = xxx_%';


  Qry["Open"]();


// Process results and insert data into the test log


  Qry["First"]();


  while (!Qry["EOF"])


 {


   var result=Qry["FieldByName"]("name")["Value"];


   Qry["Next"]();


 }


// Closes the query


  Qry["Close"]();


Log["Message"](result)


 return result;


} 



Regards,

raluca