End of file problem

[brucevde]

Is the recordset open after executing the stored procedure? Check it's State property.

If rsDates.State = 1 Then 'adStateOpen
   if NOT rsDates.EOF then
      Response.Write "you have found some records from database"
      strLoad = rsDates("LoadDate")
   end if
 
   if rsDates.EOF then
     Response.Write "NO RECORDS FOR DATES FOUND"
   end if
Else
     Response.Write "Recordset is not open"
End If

If the stored procedure contains more than 1 Select statement add a

Set NoCount On

to the beginning of the procedure.