SQL Select Quesries

Results 1 to 2 of 2

Thread: SQL Select Quesries

  1. #1
    Join Date
    Dec 1969

    Default SQL Select Quesries

    OK am I being thick here? I want to do a simple test to see if a select statement I am performing is returning a value, I have got it to print a line when it has a result, BUT if there is no matching record it simply gives this horrible message.......<BR><BR>Error Type:<BR>ADODB.Field (0x80020009)<BR>Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.<BR>/jc/LeftLoggingIn.asp<BR><BR>HELP!!!!!!!!!

  2. #2
    Eddie Campbell Guest

    Default Test for EOF (End of file)

    If rs.EOF then<BR> Response.Write "No matching records"<BR>else<BR> Response.write "You found some data"<BR>End if

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts