今天,一個(gè)招聘頁(yè)面的打開(kāi)后,頁(yè)面中出現(xiàn)如下提示:
ADODB.Field 錯(cuò)誤'80020009' BOF 或 EOF 中有一個(gè)是“真”,或者當(dāng)前的記錄已被刪除,所需的操作要求一個(gè)當(dāng)前的記錄。 /ad/henganbz/zhaopin.asp,行 0
這個(gè)是新注冊(cè)的企業(yè)。它有一個(gè)招聘頁(yè)面,頁(yè)面中出現(xiàn)如上提示。
經(jīng)檢查發(fā)現(xiàn)源代碼中有有問(wèn)題
原來(lái)是 <%for i=1 to n
if i mod 2 then %>
<tr>
<td width="50%"> <a target="_blank" href="/rencai/company/qiye-zhaopinck.asp?QiYe_Id=<%=qiye_id%>&Id=<% =rec2("id") %>"><%=rec2("ZhaoPinZhiWei")%> <%=rec2("ZhaoPinRenShu")%>人</a>
<%rec2.movenext%>
</td>
<%else%>
<td width="50%"><a target="_blank" href="/rencai/company/qiye-zhaopinck.asp?QiYe_Id=<%=qiye_id%>&Id=<% =rec2("id") %>"><%=rec2("ZhaoPinZhiWei")%> </a><a target="_blank" href="/rencai/qiye/QiYe_ZhaoPin_All-1.asp?QiYe_Id=<%=qiye_id%>&Id=<% =rec2("id") %>"><%=rec2("ZhaoPinRenShu")%></a><a target="_blank" href="/rencai/qiye/QiYe_ZhaoPin_All-1.asp?QiYe_Id=<%=qiye_id%>&Id=<% =rec2("id") %>">人
</a><a target="_blank" href="/rencai/company/qiye-zhaopinck.asp?QiYe_Id=<%=qiye_id%>&Id=<% =rec2("id") %>">
<%rec2.movenext%>
</a><a target="_blank" href="/rencai/company/qiye-zhaopinck.asp?QiYe_Id=<%=qiye_id%>&Id=<% =rec2("id") %>">
</a></td>
</tr>
<%end if
next
if n mod 2 then %>
<td width="50%"> </td>
</tr>
<%end if
rec2.movefirst%>
修改方法是:將每一個(gè)然后在每個(gè)<%rec2.movenext%>后面加上
<%if rec2.eof then exit for end if%>
結(jié)果是:
<%for i=1 to n
if i mod 2 then %>
<tr>
<td width="50%"> <a target="_blank" href="/rencai/company/qiye-zhaopinck.asp?QiYe_Id=<%=qiye_id%>&Id=<% =rec2("id") %>"><%=rec2("ZhaoPinZhiWei")%> <%=rec2("ZhaoPinRenShu")%>人</a>
<%rec2.movenext%>
<%if rec2.eof then exit for end if%>
</td>
<%else%>
<td width="50%"><a target="_blank" href="/rencai/company/qiye-zhaopinck.asp?QiYe_Id=<%=qiye_id%>&Id=<% =rec2("id") %>"><%=rec2("ZhaoPinZhiWei")%> </a><a target="_blank" href="/rencai/qiye/QiYe_ZhaoPin_All-1.asp?QiYe_Id=<%=qiye_id%>&Id=<% =rec2("id") %>"><%=rec2("ZhaoPinRenShu")%></a><a target="_blank" href="/rencai/qiye/QiYe_ZhaoPin_All-1.asp?QiYe_Id=<%=qiye_id%>&Id=<% =rec2("id") %>">人
</a><a target="_blank" href="/rencai/company/qiye-zhaopinck.asp?QiYe_Id=<%=qiye_id%>&Id=<% =rec2("id") %>">
<%rec2.movenext%>
<%if rec2.eof then exit for end if%>
</a><a target="_blank" href="/rencai/company/qiye-zhaopinck.asp?QiYe_Id=<%=qiye_id%>&Id=<% =rec2("id") %>">
</a></td>
</tr>
<%end if
next
if n mod 2 then %>
<td width="50%"> </td>
</tr>
<%end if
rec2.movefirst%>
更多信息請(qǐng)查看IT技術(shù)專欄