救命啊,asp invoke 存储过程,出错
<%
set dbconnection = Server.CreateObject("ADODB.connection")
dbconnection.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;password =klmycity;Initial Catalog=test;Data Source=localhost"
set cmd=server.CreateObject("adodb.command")
set cmd.ActiveConnection=dbconnection
cmd.CommandType = 4
cmd.CommandText="Ptest"
cmd.Parameters.Append cmd.CreateParameter("@Kname",adchar,adParamInput,10)
cmd.Parameters.Append cmd.CreateParameter("@Kpass",adchar,adParamInput,10)
cmd("@Kname") = request("name")
cmd("@Kpass") = request("pass")
cmd.execute()
%>
存储过程Ptest执行没有问题,可ASP调用 的时候总是提示:
变量或者类型不正确,或者不在可以接受的范围之内,要不就是与其他数据冲突