call stored Proc using Javascript.Plezzzzzzzzzzz Help

[Guest Rohini]

Hi all, I want to use stored proc in ASP project.And i want to call that stored Proc using Javascript.Plezz help me.Its very urgent.. Following code is in VBscript code but how can i call it in javascript????<%Set objCmd= Server.CreateObject("ADODB.Command")Set objRS= Server.CreateObject("ADODB.Recordset")objCmd.commandText ="UpdateCompWebStatus"objCmd.commandType = 4Set objCmd.ActiveConnection= objConn Set objParam = objCmd.CreateParameter("@del_inqid",200,1,20)objCmd.Parameters.append objParamobjCmd("@inquiryid")=inquiryid call CheckCommandParams( objCmd, "UpdateCompWebStatus")Set objRS=objCmd.execute%>Thanx ..........Please Help.......................................

[Skemcin]

Javascript is a client side language and a Stored Procedure is a Database Function (server side). Javascript will not be able to directly execute a stored procedure unless the javascript is calling a page on the server to do it.

[aspnetguy]

Set objCmd= new ActiveXObject("ADODB.Command")objRS= new ActiveXObject("ADODB.Recordset");objCmd.commandText ="UpdateCompWebStatus";objCmd.commandType = 4objCmd.ActiveConnection= objConn;objParam = objCmd.CreateParameter("@del_inqid",200,1,20);objCmd.Parameters.append objParam;objCmd("@inquiryid")=inquiryidCheckCommandParams( objCmd, "UpdateCompWebStatus")objRS=objCmd.execute