标题:错误类型:BOF 或 EOF 中有一个是“真”
只看楼主
chiyuan1211
Rank: 1
等 级:新手上路
帖 子:2
专家分:0
注 册:2009-10-23
结帖率:0
已结贴  问题点数:20 回复次数:5 
错误类型:BOF 或 EOF 中有一个是“真”
ADODB.Field 错误 '80020009'

BOF 或 EOF 中有一个是“真”,或者当前的记录已被删除,所需的操作要求一个当前的记录。

/mcy/Mibaoka.Asp,行 0


以下是代码:

<!--#include file="../Conn.asp"-->
<%
if request("UserName")="" then
resposne.end
end if

    Set Rs = Server.CreateObject("Adodb.Recordset")
Sql = "Select * From Mibao where UserName='" & Request("UserName") &"'"
    Rs.Open Sql,Conn,1,3
%>
<%
if not(rs.eof and rs.bof) then
do while not rs.eof
%>     
<% rs.movenext
loop
end if
%>
<body style="background-color:#000;">
            <TABLE borderColor=#ffd700 cellSpacing=0 cellPadding=0 width=460
            align=center background="" border=1 background:#0000ff>
              <TBODY>
              <TR>
                <TD width=117 height=17>
                  <DIV class=style1 align=right>
                  <DIV align=right><SPAN style="COLOR: #ff0000"><FONT
                  color=#ffd700>游戏帐号:</FONT></SPAN></DIV></DIV></TD>
                <TD width=337 height=17>
                  <DIV align=left><INPUT id=as1 style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 150px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 14px" maxLength=11 name=title value="<%=Rs("UserName")%>"><FONT color=#ffd700> <SPAN
                  style="COLOR: #ff0000"><SPAN class=style1><SPAN
                  style="COLOR: #ff0000"></SPAN></SPAN></SPAN></FONT></DIV></TD></TR>
              <TR>
                <TD height=17>
                  <DIV class=style1 align=right>
                  <DIV align=right><SPAN style="COLOR: #ff0000"><FONT
                  color=#ffd700>密保卡序列号:</FONT></SPAN></DIV></DIV></TD>
                <TD height=17>
                  <DIV align=left><INPUT id=as2
                  style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 150px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 14px"
                  maxLength=12 name=name value="<%=Rs("serial")%>"><FONT color=#ffd700> <SPAN
                  style="COLOR: #ff0000"><SPAN class=style1><SPAN
                  style="COLOR: #ff0000"></SPAN></SPAN></SPAN></FONT></DIV></TD></TR>
              <TR>
                <TD width=117 height=30>
                  <DIV class=style1 align=right>
                  </DIV></TD>
                <TD vAlign=bottom align=middle width=337 background=""
height=30>
                  <DIV align=left>
                  <TABLE style="WIDTH: 156px; HEIGHT: 219px" height=219
                  cellSpacing=0 cellPadding=0 width=156 align=left border=0>
                    <TBODY>
                    <TR vAlign=bottom align=middle>
                      <TD width=18 height=14>
                        <P class=style1 align=center><FONT
                        color=#ffd700>&nbsp;&nbsp;&nbsp;</FONT></P></TD>
                      <TD width=20>
                        <P class=style1 align=center><FONT color=#ffd700
                        size=3>1</FONT></P></TD>
                      <TD width=20>
                        <P class=style1 align=center><FONT color=#ffd700
                        size=3>2</FONT></P></TD>
                      <TD width=20>
                        <P class=style1 align=center><FONT color=#ffd700
                        size=3>3</FONT></P></TD>
                      <TD width=20>
                        <P class=style1 align=center><FONT color=#ffd700
                        size=3>4</FONT></P></TD>
                      <TD width=20>
                        <P class=style1 align=center><FONT color=#ffd700
                        size=3>5</FONT></P></TD>
                      <TD width=20>
                        <P class=style1 align=center><FONT color=#ffd700
                        size=3>6</FONT></P></TD>
                      <TD width=20>
                        <P class=style1 align=center><FONT color=#ffd700
                        size=3>7</FONT></P></TD>
                      <TD width=20>
                        <P class=style1 align=center><FONT color=#ffd700
                        size=3>8</FONT></P></TD></TR>
                    <TR vAlign=center align=middle>
                      <TD height=14>
                        <P class=style1 align=center><FONT color=#ffd700
                        size=3>A</FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><INPUT id=a1
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("a1")%>"><FONT color=#ffd700>
                      </FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=a2
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content  value="<%=rs("a2")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=a3
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("a3")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=a4
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("a4")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=a5
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("a5")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=a6
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("a6")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=a7
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("a7")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=a8
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("a8")%>"></FONT></P></TD></TR>
                    <TR vAlign=center align=middle>
                      <TD height=14>
                        <P class=style1 align=center><FONT color=#ffd700
                        size=3>B</FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=b1
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("b1")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=b2
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("b2")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=b3
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("b3")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=b4
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("b4")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=b5
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("b5")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=b6
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("b6")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=b7
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("b7")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=b8
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("b8")%>"></FONT></P></TD></TR>
                    <TR vAlign=center align=middle>
                      <TD height=14>
                        <P class=style1 align=center><FONT color=#ffd700
                        size=3>C</FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=c1
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("c1")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=c2
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("c2")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=c3
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("c3")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=c4
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("c4")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=c5
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("c5")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=c6
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("c6")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=c7
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("c7")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=c8
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("c8")%>"></FONT></P></TD></TR>
                    <TR vAlign=center align=middle>
                      <TD height=14>
                        <P class=style1 align=center><FONT color=#ffd700
                        size=3>D</FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=d1
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("d1")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=d2
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("d2")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=d3
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("d3")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=d4
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("d4")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=d5
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("d5")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=d6
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("d6")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=d7
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("d7")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=d8
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("d8")%>"></FONT></P></TD></TR>
                    <TR vAlign=center align=middle>
                      <TD height=14>
                        <P class=style1 align=center><FONT color=#ffd700
                        size=3>E</FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e1
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("e1")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e2
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("e2")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e3
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("e3")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e4
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("e4")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e5
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("e5")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700>
                          <input id=e6
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxlength=2 name=e value="<%=rs("e6")%>">
                        </FONT></P></TD>
                        
                        
                                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700>
                          <input id=e7
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxlength=2 name=e value="<%=rs("e7")%>">
                        </FONT></P></TD>
                        
                                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700>
                          <input id=e8
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxlength=2 name=e value="<%=rs("e8")%>">
                        </FONT></P></TD>
                                      <TD vAlign=center align=middle>
                      <TR vAlign=center align=middle>
                      <TD height=14>
                        <P class=style1 align=center><FONT color=#ffd700
                        size=3>F</FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e1
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("F1")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e2
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("F2")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e3
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("F3")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e4
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("F4")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e5
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("F5")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700>
                          <input id=e6
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxlength=2 name=e value="<%=rs("F6")%>">
                        </FONT></P></TD>
                        
                        
                                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700>
                          <input id=e7
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxlength=2 name=e value="<%=rs("F7")%>">
                        </FONT></P></TD>
                        
                                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700>
                          <input id=e8
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxlength=2 name=e value="<%=rs("F8")%>">
                        </FONT></P></TD>
                      <TD vAlign=center align=middle>
                     
                     
                     
                     
                     
                                              <TD vAlign=center align=middle>
                      <TR vAlign=center align=middle>
                      <TD height=14>
                        <P class=style1 align=center><FONT color=#ffd700
                        size=3>G</FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e1
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("G1")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e2
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("G2")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e3
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("G3")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e4
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("G4")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e5
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("G5")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700>
                          <input id=e6
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxlength=2 name=e value="<%=rs("G6")%>">
                        </FONT></P></TD>
                        
                        
                                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700>
                          <input id=e7
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxlength=2 name=e value="<%=rs("G7")%>">
                        </FONT></P></TD>
                        
                                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700>
                          <input id=e8
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxlength=2 name=e value="<%=rs("G8")%>">
                        </FONT></P></TD>
                      <TD vAlign=center align=middle>
                     
                     
                     
                     
                                                 <TD vAlign=center align=middle>
                      <TR vAlign=center align=middle>
                      <TD height=14>
                        <P class=style1 align=center><FONT color=#ffd700
                        size=3>H</FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e1
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("H1")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e2
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("H2")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e3
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("H3")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e4
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("H4")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e5
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("H5")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700>
                          <input id=e6
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxlength=2 name=e value="<%=rs("H6")%>">
                        </FONT></P></TD>
                        
                        
                                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700>
                          <input id=e7
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxlength=2 name=e value="<%=rs("H7")%>">
                        </FONT></P></TD>
                        
                                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700>
                          <input id=e8
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxlength=2 name=e value="<%=rs("H8")%>">
                        </FONT></P></TD>
                      <TD vAlign=center align=middle>
                     
                     
                     
                     
                     
                     
                     
                     
                                                 <TD vAlign=center align=middle>
                      <TR vAlign=center align=middle>
                      <TD height=14>
                        <P class=style1 align=center><FONT color=#ffd700
                        size=3>I</FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e1
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("I1")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e2
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("I2")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e3
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("I3")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e4
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("I4")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e5
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("I5")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700>
                          <input id=e6
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxlength=2 name=e value="<%=rs("I6")%>">
                        </FONT></P></TD>
                        
                        
                                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700>
                          <input id=e7
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxlength=2 name=e value="<%=rs("I7")%>">
                        </FONT></P></TD>
                        
                                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700>
                          <input id=e8
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxlength=2 name=e value="<%=rs("I8")%>">
                        </FONT></P></TD>
                      <TD vAlign=center align=middle>
                     
                     
                     
                     
                     
                     
                     
                                                 <TD vAlign=center align=middle>
                      <TR vAlign=center align=middle>
                      <TD height=14>
                        <P class=style1 align=center><FONT color=#ffd700
                        size=3>J</FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e1
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("J1")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e2
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("J2")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e3
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("J3")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e4
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("J4")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700><INPUT id=e5
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxLength=2 name=content value="<%=rs("J5")%>"></FONT></P></TD>
                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700>
                          <input id=e6
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxlength=2 name=e value="<%=rs("J6")%>">
                        </FONT></P></TD>
                        
                        
                                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700>
                          <input id=e7
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxlength=2 name=e value="<%=rs("J7")%>">
                        </FONT></P></TD>
                        
                                      <TD vAlign=center align=middle>
                        <P align=center><FONT color=#ffd700>
                          <input id=e8
                        style="BORDER-RIGHT: #313e16 1px solid; BORDER-TOP: #313e16 1px solid; BACKGROUND: #f4f9db; BORDER-LEFT: #313e16 1px solid; WIDTH: 20px; BORDER-BOTTOM: #313e16 1px solid; HEIGHT: 15px"
                        maxlength=2 name=e value="<%=rs("J8")%>">
                        </FONT></P></TD>
                      <TD vAlign=center align=middle>
搜索更多相关主题的帖子: 类型 EOF BOF 
2009-10-23 11:51
chiyuan1211
Rank: 1
等 级:新手上路
帖 子:2
专家分:0
注 册:2009-10-23
得分:0 
请问大家到底错误在哪?怎么修改呢?
2009-10-23 11:51
hmhz
Rank: 7Rank: 7Rank: 7
等 级:贵宾
威 望:30
帖 子:1890
专家分:503
注 册:2006-12-17
得分:6 
没看出哪里有问题

[编程论坛] ASP超级群:49158383  敲门暗号:ASP编程
龍艺博客 http://www.
2009-10-23 12:33
msgj
Rank: 8Rank: 8
等 级:蝙蝠侠
威 望:4
帖 子:190
专家分:914
注 册:2009-10-3
得分:6 

if request("UserName")="" then  
resposne.end
end if
中resposne.end写错了, 改为response.End
2009-10-23 17:04
aspic
Rank: 17Rank: 17Rank: 17Rank: 17Rank: 17
等 级:贵宾
威 望:51
帖 子:2258
专家分:8050
注 册:2008-2-18
得分:6 
哇 LS的 这都让你看出来了
2009-10-23 17:35
msgj
Rank: 8Rank: 8
等 级:蝙蝠侠
威 望:4
帖 子:190
专家分:914
注 册:2009-10-3
得分:0 
if not(rs.eof and rs.bof) then
do while not rs.eof  
%>      
<% rs.movenext  
loop  
end if  
结构也得改,
do while  
...
loop结束后,记录就结束了,后面的Rs("UserName")字段值就没有了,操作数据最好先rs.movefirst,参考下面的结构试试:

<%
if not(rs.eof and rs.bof) then
rs.movefirst
do while not rs.eof  
%>     
 <body style="background-color:#000;">
            <TABLE borderColor=#ffd700 cellSpacing=0 cellPadding=0 width=460
       align=center background="" border=1 background:#0000ff>

     ......

 
<% rs.movenext  
%>
</body>
<%loop
end if %>
2009-10-23 18:16



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-289596-1-1.html




关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.578453 second(s), 7 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved