各位大虾帮忙看下这个存储过程调用的错误!谢谢!!!
duber 2004-12-16 10:33:58 过程调用代码:
Set Comm.ActiveConnection=Conn
Comm.CommandText="Pro_SuccessTotal_Main"
Comm.CommandType=4'adCmdStoredProc
Comm.Parameters.Append Comm.CreateParameter("@codestr",adVarChar,adParamInput,1000,CodeStr)
Comm.Parameters.Append Comm.CreateParameter("@id",adInteger,adParamInput,ID)
Comm.Parameters.Append Comm.CreateParameter("@un_mt",adInteger,adParamInput,SucessLower)
Comm.Parameters.Append Comm.CreateParameter("@up_mt",adInteger,adParamInput,SucessUpper)
Comm.Parameters.Append Comm.CreateParameter("@Type",adInteger,adParamInput,Statu)
Comm.Parameters.Append Comm.CreateParameter("@SearchId",adVarChar,adParamInput,20,SearchId)
Comm.CommandTimeOut=600
Comm.execute
出错信息:
ADODB.Command 错误 '800a0bb9'
参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。
/FeeUserTotal/index.asp,行277
存储过程:
CREATE proc Pro_SuccessTotal_Main
@codestr varchar(1000),
@id int,
@un_mt int,
@up_mt int,
@Type int,
@SearchId varchar(20)
as