bof 或 eof 中有一个是“真”,或者当前的记录已被删除,所需的操作要求一个当前的记录。用的access数据库
@ 就是爱*笑
2024-06-05 11:30:15
最佳回答
<table width=''80%'' border=''0'' cellspacing=''4'' cellpadding=''0''> <tr> <td colspan=''2''><font color=''#000000'' size=''2''>签收用户列表:</font> </td> </tr> <tr> <td width=''11%''> <font size=''2''> </font></td> <td width=''89%''><font size=''2''> <%set rs=server.createobject(''adodb.recordset'')rs.open ''select * from qianshou where article_id='''&articleid&''''',conn,1,1if rs.eof and rs.bof then response.write ''[没有这个参数]''else qs_namel**t=rs(''user_l**t'')response.write rs(''user_l**t'')rs.closeset rs=nothing%> </font></td> </tr> <tr> <td colspan=''2''><font color=''#000000'' size=''2''>各单位签收情况如下:</font></td> </tr> </table> <table width=''80%'' border=''1'' cellpadding=''0'' cellspacing=''1'' bordercolor=''#6699ff''> <tr> <td height=''25'' align=''center''><strong>部门</strong></td> <td align=''center''><strong>签收时间</strong></td> <td align=''center''><strong>ip</strong></td> </tr> <%qs_namel**t0=qs_namel**tset rs=server.createobject(''adodb.recordset'')rs.open ''select * from qs_l**t where articleid='''&articleid&''' order by id desc'',conn,1,1if rs.eof and rs.bof then response.write ''[没有这个参数]''else do while not rs.eofqs_namel**t=replace(qs_namel**t,rs(''name''),'''')rs.movenextlooprs.movefirstaaa=split(qs_namel**t,'','') for i=0 to ubound(aaa) if len(aaa(i))>2 then%><tr> <td height=''24'' bgcolor=''#ffffff''> <div align=''center'' style=''color:red''><%=aaa(i)%></div></td> <td bgcolor=''#ffffff''> <div align=''center'' style=''color:red''>未签收</div></td> <td bgcolor=''#ffffff''> <div align=''center'' style=''color:red''>未签收</div></td> </tr><% end ifnextrs.movenextloopdo while not rs.eofnum=num+1%><tr> <td height=''24'' bgcolor=''#ffffff''><%=rs(''name'')%> <div align=''center''></div></td> <td bgcolor=''#ffffff''><%=rs(''time'')%> <div align=''center''></div></td> <td bgcolor=''#ffffff''><%=rs(''ip'')%> <div align=''center''></div></td> </tr> <%end ifrs.movenextlooprs.closeset rs=nothingend if%> </table></center>试试看 20210311