注册 登录
编程论坛 ASP技术论坛

循环错误 '80020009'

yaozongyue 发布于 2010-11-15 11:19, 521 次点击
错误代码
<%
i=2
set rs0=server.createobject("adodb.recordset")
sql0="select  DISTINCT top 16 company_id,lastchange  from job_view where verification=1 and disclose=1 order by lastchange desc"
rs0.open sql0,conn,1,1
do while not rs0.eof or rs0.bof or i>5%>
            <%if i>16 then%>
            <div class="qijd_lan">
            <%else%>
            <div class="qijd">
            <%end if%>
            <table width="210" style="font-size:12px" height="91" border="0" cellpadding="0" cellspacing="0">
              <tr>
                <td height="50%" valign="middle">
                <%
                set rs=server.createobject("adodb.recordset")
                sql="select   *  from company where id="&rs0("company_id")&"  "
                rs.open sql,conn,1,1
                kk=rs("company")
                set rs1=server.createobject("adodb.recordset")
                sql1="select  top 3  *  from job_view where company_id="&rs("id")&" order by id desc "
                rs1.open sql1,conn,1,1
                %>
                <%if isnull(rs("mobel")) then%>·
                                          <a href="../company/company_show.asp?id=<%=rs("id")%>" target="_blank"><%=kk%></a>
                                          <%else%>
                                          <a href="../temp/<%=rs("mobel")%>/index.asp?id=<%=rs("id")%>" target="_blank"><font color="#CC0000"><%=kk%></font></a>
                        <%end if%></td>
              </tr>
              <tr><td>&nbsp;
              <%do while not rs1.eof
                jobFunction1=rs1("jobFunction1")%>
                <a href='../company/job_show.asp?id=<%=rs1("id")%>' target="_blank">
                <script language=javascript>Showcatelogs(<%=jobFunction1%>);</script>
                </a><span class="style23">/</span>
                <%
                rs1.movenext
                loop
                rs1.close
                set rs1=nothing%>
              </td></tr>
            </table></div>
            <%
            i=i+2
            rs0.movenext
            loop
            rs0.close
            set rs0=nothing%>
6 回复
#2
yaozongyue2010-11-15 11:19
麻烦各位给解决一下
#3
wangjy5002010-11-15 12:32
sql="select   *  from company where id="&rs0("company_id")&"  "
-->
sql="select   *  from company where id="&rs0("company_id")
#4
yaozongyue2010-11-15 14:35
还是不行
#5
mai_252010-11-15 14:55
<%
i=2
set rs0=server.createobject("adodb.recordset")
sql0="select  DISTINCT top 16 company_id,lastchange  from job_view where verification=1 and disclose=1 order by lastchange desc"
rs0.open sql0,conn,1,1
do while not rs0.eof or rs0.bof or i>5%>
            <%if i>16 then%>
            <div class="qijd_lan">
            <%else%>
            <div class="qijd">
            <%end if%>
            <table width="210" style="font-size:12px" height="91" border="0" cellpadding="0" cellspacing="0">
              <tr>
                <td height="50%" valign="middle">
                <%
                set rs=server.createobject("adodb.recordset")
                sql="select   *  from company where id="&rs0("company_id")&"  "
                rs.open sql,conn,1,1
                kk=rs("company")
                set rs1=server.createobject("adodb.recordset")
                sql1="select  top 3  *  from job_view where company_id="&rs("id")&" order by id desc "
                rs1.open sql1,conn,1,1
                if not rs1.eof then
                %>
                <%if isnull(rs("mobel")) then%>·
                                          <a href="../company/company_show.asp?id=<%=rs("id")%>" target="_blank"><%=kk%></a>
                                          <%else%>
                                          <a href="../temp/<%=rs("mobel")%>/index.asp?id=<%=rs("id")%>" target="_blank"><font color="#CC0000"><%=kk%></font></a>
                        <%end if%></td>
              </tr>
              <tr><td>&nbsp;
              <%
                k=0
                while not rs1.eof
                k=k+1
                jobFunction1=rs1("jobFunction1")%>
                <a href='../company/job_show.asp?id=<%=rs1("id")%>' target="_blank">
                <script language=javascript>Showcatelogs(<%=jobFunction1%>);</script>
                </a><span class="style23">/</span>
                <%
                rs1.movenext
                wend
                end if
                rs1.close
                set rs1=nothing%>
              </td></tr>
            </table></div>
            <%
            i=i+2
            rs0.movenext
            loop
            rs0.close
            set rs0=nothing%>

[ 本帖最后由 mai_25 于 2010-11-15 14:59 编辑 ]
#6
yaozongyue2010-11-15 15:13
麻烦各位在给看看
#7
yaozongyue2010-11-15 15:26
还是不行--其实我是个菜鸟--我不确定是代码的问题
1