javascript调用存储过程的问题

[明珠佩佩]

javascript调用存储过程的问题

以下是部分代码，经测试通过的

var id=String(Request.QueryString("id"));
if(id.match(/^(0|[1-9]\d*)$/))
{
var dbConn=Server.CreateObject("adodb.connection");
dbConn.Open(Application("strConn"));
var dbCmd=Server.CreateObject("adodb.command");
with(dbCmd){
ActiveConnection = dbConn;
CommandType = 4;
CommandText = "sql_tree";
var objRs=Execute(null,parseInt(id));
}
objRs=null;
dbCmd=null;
dbConn=null;
}

但如果有多个参数，比如增加一个参数idTemp,

调用另一个有两个输入参数的存储过程sql_tree_temp

那该如何写呢?
var id=String(Request.QueryString("id"));
var idTemp=String(Request.QueryString("idTemp"));

if(id.match(/^(0|[1-9]\d*)$/))
{
var dbConn=Server.CreateObject("adodb.connection");
dbConn.Open(Application("strConn"));
var dbCmd=Server.CreateObject("adodb.command");
with(dbCmd){
ActiveConnection = dbConn;
CommandType = 4;
CommandText = "sql_tree_temp";
var objRs=Execute(null,parseInt(id));
//---------------------------------------------------^???????
}
objRs=null;
dbCmd=null;
dbConn=null;
}

[明珠佩佩]

自己顶！~

[明珠佩佩]

没人知道吗？

[NavigationFox]

with(dbCmd){
ActiveConnection = dbConn;
CommandType = 4;
CommandText = "sql_tree_salaryunits";
Parameters.Refresh;
Parameters.Append = CreateParameter("@ID", 3, &H0001, &H0004, parseInt(id));
Parameters.Append = CreateParameter("IDTemp", 3, &H0001, &H0004, parseInt(IDTemp));
var objRs=Execute;
}