Question

ADODB.Command '800a0bb9' 错误

ADODB.Command '800a0bb9'

参数类型不正确，或不在可以接受的范围之内，或与其他参数冲突。

\reg.asp, line 39

下面是代码

<link href="css/css.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
body {
margin-left: 15px;
margin-top: 15px;
}
-->
</style><!--#include file = "ADOVBS.inc"-->
<!--#include file = "md5.asp"-->
<!--#include file = "conn.asp"-->

<%

cdkey = trim(request("cdkey"))
password = trim(request("password"))
confirm_password = trim(request("confirm_password"))

if (password <> confirm_password) then
response.write "2次输入的密码不一致"
response.end
end if

set rs=server.CreateObject("adodb.recordset")
strsql="select cdkey from CSL_CDKEY where cdkey='"&trim(request("cdkey"))&"'"
rs.open strsql,conn,1,1
if not( rs.eof and rs.bof ) then
response.write"注册失败"
response.write"你输入的用户名已经存在,请重新输入!<a href=javascript:history.go(-1)><font color=red>按此返回!</font>"
rs.close
else

crypt_password = CSTR(md5(password))
set cmd=server.CreateObject("adodb.command")

Set cmd.ActiveConnection = conn
cmd.CommandType = adCmdStoredProc
cmd.CommandText = "sp_InsertCDKEY"

Set param = cmd.createparameter("@cdkey", advarchar, adparaminput, 50, cdkey)
cmd.Parameters.Append param

Set param = cmd.createparameter("@password", advarchar, adparaminput, 50, crypt_password)
cmd.Parameters.Append param

cmd.Parameters.Append cmd.CreateParameter("@_error",adInteger,adParamOutput)
cmd.Execute()

result=0
select case result
case 1
response.write"用户不能为空!!"
case 2
response.write"password不能null或空!!"
case 3
response.write"此帐号存在!!"
case 0
response.write"感谢您注册成功!"
end select
end if
%>

求解怎么回事?其他页面都可以进，就注册帐号的时候出现错误

Answer 1

到底是哪一行呢

参数类型不正确，或不在可以接受的范围之内，或与其他参数冲突。
估计是
strsql="select cdkey from CSL_CDKEY where cdkey='"&trim(request("cdkey"))&"'"
这里的问题
检查一下吧

Answer 2

看不明白