sql query

Results 1 to 3 of 3

Thread: sql query

  1. #1
    sql query Guest

    Default sql query

    i am doing a simple SQL statement which accepts a parameter "USERID".it works fine if there is record but some times there is no record for that userid.then it gives this error:<BR>Error Type:<BR>ADODB.Field (0x800A0BCD)<BR>Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.<BR><BR>is there any way to cope with this situation?.

  2. #2
    New ASP Guest

    Default RE: sql query

    obj_rec.open ........<BR><BR>IF NOT obj_rec.EOF AND NOT obj_rec.BOF THEN<BR>obj_rec.movefirst<BR>:<BR>:<BR>ELSE<BR>res ponse.write "empty"<BR><BR>END IF

  3. #3
    sql query Guest

    Default thanks


Posting Permissions

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