为过程或函数 SP_MODI_TASK_S 指定的参数太多。
[P]原代码是：[/P][P]Sub TASKMODIS
'建一个Command对象
Dim cmd
Set cmd = Server.CreateObject("Adodb.Command")
'建立连接
cmd.ActiveConnection = conn
cmd.commandtext = "SP_MODI_TASK_S"
cmd.commandtype = adcmdStoredProc
cmd.Parameters.Append cmd.CreateParameter("@IN_QUESTIONID", adBigInt, adParaminput, 8, QUESTIONID)
cmd.Parameters.Append cmd.CreateParameter("@IN_TITLE", adVarChar, adParaminput, 200, TITLE)
cmd.Parameters.Append cmd.CreateParameter("@IN_ASKCONTENT", adLongVarChar, adParaminput, 2000, CONTENT)
cmd.Parameters.Append cmd.CreateParameter("@IN_CLASSID", adSmallInt, adParaminput, 2, CLASSID)
cmd.Parameters.Append cmd.CreateParameter("@IN_STATUS", adSmallInt, adParaminput, 2, STATUS)
cmd.Parameters.Append cmd.CreateParameter("@IN_SUPPLEMENT", adVarChar, adParaminput, 200, SUPPLEMENT)
'运行存储过程
cmd.Execute()
'清除对象
Set cmd.ActiveConnection=Nothing
Set cmd = Nothing
End Sub[/P][P] [/P][P]--------------------------[/P][P]后加了个
cmd.Parameters.Append cmd.CreateParameter("@IN_ANSWERCONTENT", adLongVarChar, adParaminput, 2000, ANSWERCONTENT)[/P][P] [/P][P]即：[/P][P]Sub TASKMODIS
'建一个Command对象
Dim cmd
Set cmd = Server.CreateObject("Adodb.Command")
'建立连接
cmd.ActiveConnection = conn
cmd.commandtext = "SP_MODI_TASK_S"
cmd.commandtype = adcmdStoredProc
cmd.Parameters.Append cmd.CreateParameter("@IN_QUESTIONID", adBigInt, adParaminput, 8, QUESTIONID)
cmd.Parameters.Append cmd.CreateParameter("@IN_TITLE", adVarChar, adParaminput, 200, TITLE)
cmd.Parameters.Append cmd.CreateParameter("@IN_ASKCONTENT", adLongVarChar, adParaminput, 2000, CONTENT)
cmd.Parameters.Append cmd.CreateParameter("@IN_CLASSID", adSmallInt, adParaminput, 2, CLASSID)
cmd.Parameters.Append cmd.CreateParameter("@IN_STATUS", adSmallInt, adParaminput, 2, STATUS)
cmd.Parameters.Append cmd.CreateParameter("@IN_SUPPLEMENT", adVarChar, adParaminput, 200, SUPPLEMENT)
cmd.Parameters.Append cmd.CreateParameter("@IN_ANSWERCONTENT", adLongVarChar, adParaminput, 2000, ANSWERCONTENT)
'运行存储过程
cmd.Execute()
'清除对象
Set cmd.ActiveConnection=Nothing
Set cmd = Nothing
End Sub
[/P][P] [/P][P]报错：[/P][P][SIZE=2] [/SIZE][/P][P]Microsoft OLE DB Provider for SQL Server[SIZE=3] [/SIZE][FACE=宋体][SIZE=2]错误 '80040e14'[/SIZE][/FACE][SIZE=3] [/SIZE][P][FACE=宋体][SIZE=2]为过程或函数 SP_MODI_TASK_S 指定的参数太多。[/SIZE][/FACE] [P] [/P][P]请问下有谁知道如何修改？[/P][P]谢谢[/P][P]
[/P]