ADODB.Recordset (0x800A0CC1)在对应所需名称或序数的集合中,未找到项目。/Reg/userinfo.asp, 第 96 行
来源:百度知道 编辑:UC知道 时间:2024/05/21 22:51:48
ADODB.Recordset (0x800A0CC1)在对应所需名称或序数的集合中,未找到项目。/Reg/userinfo.asp, 第 96 行
代码如下:
<% sql = "select * from user_web_cart a,avatarlist b where a.userid='"&userID&"' and a.itemidx=b.Itemid "
set rs = Conn.execute(sql)
if rs.eof then
%>
<tr align="center">
<td colspan="6" height="26">暂时还没有相关的物品数据!</td>
</tr>
<%else%>
<tr align="center">
<td colspan="6"><br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td
代码如下:
<% sql = "select * from user_web_cart a,avatarlist b where a.userid='"&userID&"' and a.itemidx=b.Itemid "
set rs = Conn.execute(sql)
if rs.eof then
%>
<tr align="center">
<td colspan="6" height="26">暂时还没有相关的物品数据!</td>
</tr>
<%else%>
<tr align="center">
<td colspan="6"><br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td
几个地方看一下:
1。
sql = "select * from user_web_cart a,avatarlist b where a.userid='"&userID&"' and a.itemidx=b.Itemid "
a.userid 如为int类型,改为 a.userid="&userID&"
2.sql2= "select * from avatarlist where Itemid="&itemid&" "
Itemid="&itemid&" " 改为 Itemid="&itemid
3.
wpmc=rs2("ItemName")
if rs2("money")=1 then
G=G+rs2("cash")
elseif rs2("cash")=1 then
M=M+rs2("money")
确认rs2的这几个字段名有没有写错
<% sql = "select * from user_web_cart a,avatarlist b where a.userid='"&userID&"' and a.itemidx=b.Itemid "
改为
<% sql = "select * from user_web_cart a,avatarlist b where a.userid='"&userID&"' and a.itemid=b.Itemid "
ADODB.Recordset (0x800A0E79)
ADODB.Recordset (0x800A0BCD)
ADODB.Recordset (0x800A0E78)
ADODB.Recordset (0x800A0BB9)
ADODB.Recordset (0x800A0E7D)
ADODB.Recordset (0x800A0BB9)问题
ADODB.Recordset 错误 (0x800A0BB9)
ADODB.Recordset (0x800A0E79)错误
ADODB.Recordset (0x800A0BCD)错误
ASP--ADODB.Recordset (0x800A0CC1)