调用存储过程中出错。

smartlife 2004-09-16 08:59:14

[set objCmd1=Server.CreateObject("Adodb.Command")
objCmd1.ActiveConnection=conn
objCmd1.CommandText="SendMailFun" '指定存储过程名称
objCmd1.CommandType=adCmdStoredProc '其为Stored Procedure
'-----准备stored procedure 的参数-------

objCmd1.Parameters.Append objCmd1.CreateParameter("@FromUserName",adVarchar,adParamInput,14,"清风围棋")
objCmd1.Parameters.Append objCmd1.CreateParameter("@ToUserName",adVarchar,adParamInput,14,Session("QfUserName"))

objCmd1.Parameters.Append objCmd1.CreateParameter("@ShortMsgType",adSmallInt,adParamInput,,1)
objCmd1.Parameters.Append objCmd1.CreateParameter("@isCheckEnemy",adTinyInt,adParamInput,,0)

objCmd1.Parameters.Append objCmd1.CreateParameter("@MsgSendTime",adDBTimeStamp,adParamInput,,date())
objCmd1.Parameters.Append objCmd1.CreateParameter("@sContent",adVarchar,adParamInput,4000,rs4("leaguename")&"第"&rs4("leagueperiod")&"期"&msg)
objCmd1.Parameters.Append objCmd1.CreateParameter("@shoryMsgID",adInteger,adParamOutput,,0)
objCmd1.Parameters.Append objCmd1.CreateParameter("@bCheckCount",adTinyInt,adParamInput,,0)
objCmd1.Parameters.Append objCmd1.CreateParameter("@sRet",adInteger,adParamOutput,100,0)

objCmd1.Parameters.Append objCmd1.CreateParameter("@isAllMember",adTinyInt,adParamInput,100,0)
objCmd1.Parameters.Append objCmd1.CreateParameter("@isAllNoMember",adTinyInt,adParamInput,100,0)

'-----执行存储过程----------------------
objCmd1.Execute

Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]形式参数 '@bCheckCount' 定义为 OUTPUT，但实际参数却未声明为 OUTPUT。

/MyRich/bet/userbet_back.asp，行219

这个是为什么。存储过程中@bCheckCount'为input呀。

...全文