javascript里如何调用存储过程（带有返回的参数）？

[51dianying]

我有一个js文件，通过cscript.exe XXX.js来运行在本机器，想在其中调用存储过程。代码如下，

var DB="DB01";
var User="report";
var Pass="report";

var ret = 1;
ret = main( "sales", 8667);//这个是测试数据，sales是部门,8667是id号码
WScript.Quit( ret );

function main(department,id)
{
var connectString = "Provider='SQLOLEDB';Data Source="+DB+";Initial Catalog=HR;User Id="+User+";Password="+Pass;
var objCon = new ActiveXObject("ADODB.Connection");

objCon.Open( connectString );
var MyComm = new ActiveXObject("ADODB.Command");

with(MyComm){
ActiveConnection = objCon;
CommandType = 4;
CommandText = "QueryPerson_SP";
Parameters.Refresh;
Parameters.Append=CreateParameter("@DepartName", 200, 1, 10, department);
Parameters.Append=CreateParameter("@PersonName", 200, 4);
Parameters.Append=CreateParameter("@PersonID",2, 1, 4, id);
var objRs=Execute;
}
WScript.Echo(retvalue);
}

目前提示的错误：

query.js(23, 3) ADODB.Parameters: Parameter object is improperly de
fined. Inconsistent or incomplete information was provided.

我想是传入参数的问题，请问如何写才能解决？试验了好多次都不行，急需大家指点！

[hookee]

with(MyComm){
ActiveConnection = objCon;
CommandType = 4;
CommandText = "QueryPerson_SP";
Parameters.Refresh();
Parameters.Append(CreateParameter("@DepartName",200,1,10,department));
Parameters.Append(CreateParameter("@PersonName",200,4));
Parameters.Append(CreateParameter("@PersonID",2,1,4,id));
var objRs=Execute();
}

[hookee]

with(MyComm){
ActiveConnection = objCon;
CommandType = 4;
CommandText = "QueryPerson_SP";
Parameters.Refresh();
Parameters["@DepartName"].Value = department;
var objRs=Execute();
}

[51dianying]

顶一下，莫沉。

[51dianying]

不行，问题一样。

[懒得去死]

http://forum.codeby.net/topic14125.html

[51dianying]

楼上推荐的网址不错，但就是俄文的，看不懂。不管如何，谢谢了。