Error: Either BOF or EOF is True, or the current record has been deleted.

Hannibal · April 6th, 2010, 06:54 AM

Hi,
I am trying to fetch the data corresponding to the dropdown box and then filling textbox with the value from database.

Code:

set Dropdownvalue = Request.Form("Select1")
 if Dropdownvalue <> "--Select--" Then 
striSQL = "SELECT Stu_Name FROM tbl_College where Stu_Name = '" & Dropdownvalue& "' " 
oRsss.Open striSQL, conn

The "--Select--" is not available in the database, I am putting that in the dropdown box.

I am getting the following error:
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

How to fix this?
Thank you

Old Pedant · April 6th, 2010, 01:18 PM

DEBUG DEBUG DEBUG

Code:

set Dropdownvalue = Request.Form("Select1")
Response.Write "DEBUG: Dropdownvalue is '" & dropdownvalue & "'<hr>"
if Dropdownvalue <> "--Select--" Then 
    striSQL = "SELECT Stu_Name FROM tbl_College where Stu_Name = '" & Dropdownvalue& "' " 
    Response.Write "DEBUG SQL: " & striSQL & "<hr>"
    oRsss.Open striSQL, conn
    If oRsss.EOF Then 
        Response.Write "DEBUG:  No records matching that SQL!!"
    Else
       ...

And so on.