主题:求助ADODB.Recordset '800a0cc1'错误,请高手帮忙
这是个游戏转生服务程序,高手帮我看看这个ASP有什么问题,我在运行时出现以下提示:
[color=FF0000]ADODB.Recordset '800a0cc1'
在对应所需名称或序数的集合中,未找到项目。
\wwwroot\reg\swwsave.asp, line 55
--------------------------------------------------------------------------------
Host by NetBox Version 2.8 Build 4128[/color]
以下是swwsave.asp文件内容:
<!--#include file="config.asp"-->
<!--#include file = "conn2.asp"-->
<%
UniqueName = trim(request("UniqueName"))
Name = trim(request("Name"))
vip = trim(request("vip"))
Zhuansheng = trim(request("Zhuansheng"))
Gold = trim(request("Gold"))
Credit = trim(request("Credit"))
youname = UniqueName+hao
youname2 = UniqueName+hao2
youname3 = UniqueName+hao3
if (UniqueName <> Name) then
response.write "<script language=javascript>alert('两次输入人物名称不一致!');window.location=('sww.asp')</script>"
response.end
end if
if request("anonum")="" then
response.write("<script>alert('请正确输入附加碼!');window.location=('sww.asp')</script>")
response.end
end if
if int(request("anonum"))<>int(session("agennum")) then
response.write("<script>alert('请正确输入附加碼!');window.location=('sww.asp')</script>")
response.end
end if
if UniqueName="" or Name="" then
response.write "<script language=javascript>alert('游戏人物不存在请核实后再提交,谢谢合作!');window.location=('sww.asp')</script>"
response.End
end if
set rs=server.CreateObject("adodb.recordset")
strsql="select * from user where UniqueName='"&trim(UniqueName)&"'"
rs.open strsql,conn,3,3
if rs.eof then
response.write "<script language=javascript>alert('您输入的人物名称错误,请重新输入!!');window.location=('sww.asp')</script>"
response.end
end if
if rs("Level")<90 then
response.write("<script>alert('您的级别低于90级!');window.location=('sww.asp')</script>")
response.end
end if
if rs("Gold")<10000000 then
response.write("<script>alert('转生经费不够!');window.location=('sww.asp')</script>")
response.end
end if
if rs("Credit")<100 then
response.write("<script>alert('转生声望不够!');window.location=('sww.asp')</script>")
response.end
end if
if rs("Zhuansheng")<1 then
Gold=rs("Gold")
Gold=Gold-news
SP=rs("SP")
SP=SP+news2
Credit=rs("Credit")
Credit=Credit-news1
AP=rs("AP")
AP=AP+new3
Zhuansheng=rs("Zhuansheng")
Zhuansheng=Zhuansheng+news4
conn.execute "update user set gold='"&gold&"',sp='"&sp&"',Credit='"&Credit&"',AP='"&AP&"',Zhuansheng='"&Zhuansheng&"',EXP=0,Level=1 where UniqueName='"&UniqueName&"'"
response.write "<script language=javascript>alert('第1次转生成功!');window.location=('sww.asp')</script>"
response.end
end if
if rs("Zhuansheng")<2 then
Gold=rs("Gold")
Gold=Gold-news
SP=rs("SP")
SP=SP+sp2
Credit=rs("Credit")
Credit=Credit-news1
AP=rs("AP")
AP=AP+ap2
Zhuansheng=rs("Zhuansheng")
Zhuansheng=Zhuansheng+news4
conn.execute "update user set gold='"&gold&"',sp='"&sp&"',Credit='"&Credit&"',AP='"&AP&"',Zhuansheng='"&Zhuansheng&"',EXP=0,Level=1 where UniqueName='"&UniqueName&"'"
response.write "<script language=javascript>alert('第2次转生成功!');window.location=('sww.asp')</script>"
response.end
end if
if rs("Zhuansheng")<3 then
Gold=rs("Gold")
Gold=Gold-news
SP=rs("SP")
SP=SP+sp3
Credit=rs("Credit")
Credit=Credit-news1
AP=rs("AP")
AP=AP+ap3
Zhuansheng=rs("Zhuansheng")
Zhuansheng=Zhuansheng+news4
conn.execute "update user set gold='"&gold&"',sp='"&sp&"',Credit='"&Credit&"',AP='"&AP&"',Zhuansheng='"&Zhuansheng&"',EXP=0,Level=1 where UniqueName='"&UniqueName&"'"
response.write "<script language=javascript>alert('第3次转生成功!');window.location=('sww.asp')</script>"
response.end
end if
if rs("Zhuansheng")<4 then
Gold=rs("Gold")
Gold=Gold-news
SP=rs("SP")
SP=SP+sp4
Credit=rs("Credit")
Credit=Credit-news1
AP=rs("AP")
AP=AP+ap4
Zhuansheng=rs("Zhuansheng")
Zhuansheng=Zhuansheng+news4
conn.execute "update user set gold='"&gold&"',sp='"&sp&"',Credit='"&Credit&"',AP='"&AP&"',Zhuansheng='"&Zhuansheng&"',EXP=0,Level=1 where UniqueName='"&UniqueName&"'"
response.write "<script language=javascript>alert('第4次转生成功!');window.location=('sww.asp')</script>"
response.end
end if
if rs("Zhuansheng")<5 then
Gold=rs("Gold")
Gold=Gold-news
SP=rs("SP")
SP=SP+sp5
Credit=rs("Credit")
Credit=Credit-news1
AP=rs("AP")
AP=AP+ap5
Zhuansheng=rs("Zhuansheng")
Zhuansheng=Zhuansheng+news4
conn.execute "update user set gold='"&gold&"',sp='"&sp&"',Credit='"&Credit&"',AP='"&AP&"',Zhuansheng='"&Zhuansheng&"',EXP=0,Level=1 where UniqueName='"&UniqueName&"'"
response.write "<script language=javascript>alert('第5次转生成功!');window.location=('sww.asp')</script>"
response.end
end if
if rs("Zhuansheng")=5 then
response.write "<script language=javascript>alert('你已经达到最高转了,不能在转');window.location=('sww.asp')</script>"
response.end
end if
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
<%=UniqueName%>
[color=FF0000]ADODB.Recordset '800a0cc1'
在对应所需名称或序数的集合中,未找到项目。
\wwwroot\reg\swwsave.asp, line 55
--------------------------------------------------------------------------------
Host by NetBox Version 2.8 Build 4128[/color]
以下是swwsave.asp文件内容:
<!--#include file="config.asp"-->
<!--#include file = "conn2.asp"-->
<%
UniqueName = trim(request("UniqueName"))
Name = trim(request("Name"))
vip = trim(request("vip"))
Zhuansheng = trim(request("Zhuansheng"))
Gold = trim(request("Gold"))
Credit = trim(request("Credit"))
youname = UniqueName+hao
youname2 = UniqueName+hao2
youname3 = UniqueName+hao3
if (UniqueName <> Name) then
response.write "<script language=javascript>alert('两次输入人物名称不一致!');window.location=('sww.asp')</script>"
response.end
end if
if request("anonum")="" then
response.write("<script>alert('请正确输入附加碼!');window.location=('sww.asp')</script>")
response.end
end if
if int(request("anonum"))<>int(session("agennum")) then
response.write("<script>alert('请正确输入附加碼!');window.location=('sww.asp')</script>")
response.end
end if
if UniqueName="" or Name="" then
response.write "<script language=javascript>alert('游戏人物不存在请核实后再提交,谢谢合作!');window.location=('sww.asp')</script>"
response.End
end if
set rs=server.CreateObject("adodb.recordset")
strsql="select * from user where UniqueName='"&trim(UniqueName)&"'"
rs.open strsql,conn,3,3
if rs.eof then
response.write "<script language=javascript>alert('您输入的人物名称错误,请重新输入!!');window.location=('sww.asp')</script>"
response.end
end if
if rs("Level")<90 then
response.write("<script>alert('您的级别低于90级!');window.location=('sww.asp')</script>")
response.end
end if
if rs("Gold")<10000000 then
response.write("<script>alert('转生经费不够!');window.location=('sww.asp')</script>")
response.end
end if
if rs("Credit")<100 then
response.write("<script>alert('转生声望不够!');window.location=('sww.asp')</script>")
response.end
end if
if rs("Zhuansheng")<1 then
Gold=rs("Gold")
Gold=Gold-news
SP=rs("SP")
SP=SP+news2
Credit=rs("Credit")
Credit=Credit-news1
AP=rs("AP")
AP=AP+new3
Zhuansheng=rs("Zhuansheng")
Zhuansheng=Zhuansheng+news4
conn.execute "update user set gold='"&gold&"',sp='"&sp&"',Credit='"&Credit&"',AP='"&AP&"',Zhuansheng='"&Zhuansheng&"',EXP=0,Level=1 where UniqueName='"&UniqueName&"'"
response.write "<script language=javascript>alert('第1次转生成功!');window.location=('sww.asp')</script>"
response.end
end if
if rs("Zhuansheng")<2 then
Gold=rs("Gold")
Gold=Gold-news
SP=rs("SP")
SP=SP+sp2
Credit=rs("Credit")
Credit=Credit-news1
AP=rs("AP")
AP=AP+ap2
Zhuansheng=rs("Zhuansheng")
Zhuansheng=Zhuansheng+news4
conn.execute "update user set gold='"&gold&"',sp='"&sp&"',Credit='"&Credit&"',AP='"&AP&"',Zhuansheng='"&Zhuansheng&"',EXP=0,Level=1 where UniqueName='"&UniqueName&"'"
response.write "<script language=javascript>alert('第2次转生成功!');window.location=('sww.asp')</script>"
response.end
end if
if rs("Zhuansheng")<3 then
Gold=rs("Gold")
Gold=Gold-news
SP=rs("SP")
SP=SP+sp3
Credit=rs("Credit")
Credit=Credit-news1
AP=rs("AP")
AP=AP+ap3
Zhuansheng=rs("Zhuansheng")
Zhuansheng=Zhuansheng+news4
conn.execute "update user set gold='"&gold&"',sp='"&sp&"',Credit='"&Credit&"',AP='"&AP&"',Zhuansheng='"&Zhuansheng&"',EXP=0,Level=1 where UniqueName='"&UniqueName&"'"
response.write "<script language=javascript>alert('第3次转生成功!');window.location=('sww.asp')</script>"
response.end
end if
if rs("Zhuansheng")<4 then
Gold=rs("Gold")
Gold=Gold-news
SP=rs("SP")
SP=SP+sp4
Credit=rs("Credit")
Credit=Credit-news1
AP=rs("AP")
AP=AP+ap4
Zhuansheng=rs("Zhuansheng")
Zhuansheng=Zhuansheng+news4
conn.execute "update user set gold='"&gold&"',sp='"&sp&"',Credit='"&Credit&"',AP='"&AP&"',Zhuansheng='"&Zhuansheng&"',EXP=0,Level=1 where UniqueName='"&UniqueName&"'"
response.write "<script language=javascript>alert('第4次转生成功!');window.location=('sww.asp')</script>"
response.end
end if
if rs("Zhuansheng")<5 then
Gold=rs("Gold")
Gold=Gold-news
SP=rs("SP")
SP=SP+sp5
Credit=rs("Credit")
Credit=Credit-news1
AP=rs("AP")
AP=AP+ap5
Zhuansheng=rs("Zhuansheng")
Zhuansheng=Zhuansheng+news4
conn.execute "update user set gold='"&gold&"',sp='"&sp&"',Credit='"&Credit&"',AP='"&AP&"',Zhuansheng='"&Zhuansheng&"',EXP=0,Level=1 where UniqueName='"&UniqueName&"'"
response.write "<script language=javascript>alert('第5次转生成功!');window.location=('sww.asp')</script>"
response.end
end if
if rs("Zhuansheng")=5 then
response.write "<script language=javascript>alert('你已经达到最高转了,不能在转');window.location=('sww.asp')</script>"
response.end
end if
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
<%=UniqueName%>