[ASP]无记录时需使用if(rs.bof and rs.eof)判断

如果表orders里没有任何一条符合记录。那么如果只用if(rs.eof) then判断会导致错误。正确做法是头指针尾指针都要判断：if(rs.bof and check.eof) then正确代码如下：

set check=server.CreateObject("adodb.recordset")
   check.open "select username from orders where charname='"&charname&"' and username<>'"&username&"' and actionid<>"&actionid&"",conn,1,1
   If (check.bof and check.eof) then
    Response.Write("无记录")
    check.close
    set check=nothing
    response.End()
   End If