rs.movenext出错

[daiweizhong]

<%
strSQL="Select * from xd1.jhj order by jhj_dk"
set rs = connMTC.Execute(strSQL)
set rs = server.CreateObject("ADODB.Recordset")
rs.Open strSql,connMTC,1,3
%>
<title>交换机列表清单</title>
<link href="image/css.css" rel="stylesheet" type="text/css" />
<script src="image/layerdetail.js"></script>
<%response.write rs.RecordCount
if rs.eof and rs.bof then
response.Write "无内容!"
else
%>
<table width="712" border="0" cellspacing="0" cellpadding="0">
<tr>
<td background="image/48.jpg" width="712" height="87" align="center" valign="bottom">
<table width="600" height="66" border="0" cellpadding="0" cellspacing="0">
<tr>
<%
do while not rs.eof
%>
<td width="22">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" valign="bottom" ><font color=ffffff><%=rs("jhj_dk")%>x</font></td>
</tr>
<tr>
<td><img onmouseover="ddrivetip('<table border=0 cellspacing=0 cellpadding=0><tr><td height=5></td></tr><tr><td height=18><img src=image/arr_green.gif> <b>IP 地 址：</b><%=rs("jhj_ip")%></td></tr><tr><td height=18><img src=image/arr_green.gif> <b>Mac地 址：</b><%=rs("jhj_mac")%></td></tr><tr><td height=18><img src=image/arr_green.gif> <b>端口地址：</b><%=rs("jhj_addr")%></td></tr><tr><td height=18><img src=image/arr_green.gif> <b>备　　注：</b><%=rs("jhj_bz")%><td><tr></table>')" onmouseout="hideddrivetip()"src="<%if rs("jhj_kg")=2 then
response.Write "image/blue.jpg"
elseif rs("jhj_kg")=1 then
response.Write "image/yellow.jpg"
else response.Write "image/black.jpg"
end if%>" width="22" height="16" border="0" /></td>
</tr>

<% if rs.eof and rs.bof then
response.write ""
else
rs.movenext
%>
<tr>
<td><img onmouseover="ddrivetip('<table border=0 cellspacing=0 cellpadding=0><tr><td height=5></td></tr><tr><td height=18><img src=image/arr_green.gif> <b>IP 地 址：</b><%=rs("jhj_ip")%></td></tr><tr><td height=18><img src=image/arr_green.gif> <b>Mac地 址：</b><%=rs("jhj_mac")%></td></tr><tr><td height=18><img src=image/arr_green.gif> <b>端口地址：</b><%=rs("jhj_addr")%></td></tr><tr><td height=18><img src=image/arr_green.gif> <b>备　　注：</b><%=rs("jhj_bz")%><td><tr></table>')" onmouseout="hideddrivetip()"src="<%if rs("jhj_kg")=2 then
response.Write "image/blue_1.jpg"
elseif rs("jhj_kg")=1 then
response.Write "image/yellow_1.jpg"
else response.Write "image/black_1.jpg"
end if%>" width="22" height="16" border="0" /></td>
</tr>

<tr>
<td align="center" valign="top"><font color=ffffff><%=rs("jhj_dk")%>x</font></td>
</tr>
<%

end if
%>
</table></td>
<%

rs.movenext
loop


%>
<td width="516"> </td>
</tr>
</table></td>
</tr>
</table>
<%end if%>


请各位看看,为什么数据为单数的时候会出错!

[Atai-Lu]

<% if rs.eof and rs.bof then
response.write ""
else
rs.movenext
%>
这里的rs.movenext后面再加上一行，if rs.eof then exit do

[zhuangjunx]

晕，，这么乱。。

[daiweizhong]

谢谢,luxu001207

[nevana]

直接合并成
<%
if not rs.eof
rs.movenext
%>
也可以吧