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,



I have a problem. I want to pass the name of a database into a variable but I don't know how. I do like this in my code:


var



commands = new Array(); 


var variable="@DBNAME";


 commands[commands.length] = "DECLARE " + variable + " NVARCHAR(max) select " + variable + " = name from sys.databases where name like xxx_%' print @DBNAME";


// Create a new object


  var Cmd =


ADO["CreateADOCommand"]();


// Specify the connection string



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


// Specify the command type



 Cmd["CommandType"]=cmdText;


for(var i = 0; i < commands.length; i++)


 {


// Specify the command text (an SQL expression)


   Cmd.CommandText = commands;


// Execute the command


Cmd.Execute();


 }


Log["Message"](variable);


 return variable;



But the result is '@DBNAME not ''xxx_' as I expect.



Regards,

Raluca