i want to give perameter in sql stored procedure using javascript.
hi
i want to give perameter to sql stored procedure using javascript. i donot know about its code some body please arrange it and tell me where i am missing.
Code:
var strConnString="Provider=SQLOLEDB;Data Source=210.116.110.51;Initial Catalog=MYDB;User ID=##;Password=#####";
var objConn = new ActiveXObject("ADODB.Connection");
var recSetObj = new ActiveXObject("ADODB.Recordset");
objConn.open(strConnString);
if(rec_time > start)
{
//here GetRecord is used as stored procedure and i want to give 2 as input perameter so that this procedure update relevent record.
var q = "Exec GetRecord";
recSetObj.Open(q,objConn);
please tell me where should i give 2 as perameter in this javascript code.