[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