是高手就进来解决ADODB.Field (0x800A0BCD)问题
代码:
<td width="100" height="22" align="center">联系地址</td>
<td width="400" height="22"> <%=rs("dz")%> [邮编:<%=rs("yb")%>]</td>
</tr>
<tr valign="middle" bgcolor="#FFFFFF">
<td height="22" align="center">拥有财富</td>
<td height="22"> <%=rs("je2")%>元</td>
</tr>
<tr valign="middle" bgcolor="#FFFFFF">
<td height="22" align="center">开店</td>
<td height="22"><%set yz = conn.execute("select id,zt,name from shop where huiyuan='"&rs("huiyuan")&"'
order by id asc")
if yz.eof then
Response.Write("未申请")
else
i=1
do while not yz.eof
Response.Write " "&i&"、<a href=/user/index.jsp?userid="&yz(0)&" target=_blank>"&yz(2)
&"</a> [状态:"
Select case yz(1)
case "0"
Response.Write("<font color=#ff0000>未审核</font>")
case "1"
Response.Write("<font color=#ff6600>试营业</font>")
case "2"
Response.Write("营业中")
case "3"
Response.Write("<font color=#ff0000><del>已过期</font>")
case "4"
Response.Write("<del>已作废")
End Select
Response.Write "]<br>"
i=i+1
yz.movenext
loop
end if
错误提示:
ADODB.Field (0x800A0BCD)
BOF 或 EOF 中有一个是“真”,或者当前的记录已被删除,所需的操作要求一个当前的记录。
shop/admin/user/user.jsp, 第 34 行