asp调用存储过程出错
(0x800A0BB9)参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。
存储过程
CREATE PROCEDURE insertinto
@name nvarchar
AS insert into Card_CircleName_index(@name)values('我是一个兵')
GO
调用语句
<%if request.Form("hiddenField")<>"" then
set cmd=server.CreateObject(")
cmd.activeconnection=conn
set circlename=cmd.createparameter("@name",adVarChar,adParamInput,20,CircleName)
cmd.parameters.append circlename
cmd.execute
response.write("<script>alert('插入成功')</script>")
end if%>