[ASP] need to use if (RS.BOF and rs.eof) to determine when there is no record

If none of the orders in the table matches the record. Then, if only the IF (rs.eof) then is judged to cause an error. The correct way to do this is to judge the end of the head pointer: if (RS.BOF and check.eof) then the correct code is as follows:

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 ("no Record")
Check.close
Set check=nothing
Response. End ()
End If