Recordset is nothing?

[Spoogledrummer]

Hi, I just completed an application that queried the database to see if a value existed in there, if it didn't then it did one thing, if it did it did another. at first I was using

If not rsblah.EOF then

and was getting Object required errors, I spent ages trying to figure out why and Google was of little use telling me I'd probably typoed, so I asked another developer and he said to do

If rsblah is nothing then

and it worked, he explained that sometimes rather than a query returning an empty recordset it didn't return one at all but he didn't know why so I thought I'd ask here if someone could explain that to me? I fully expected my recordset to return empty as there's no data in the table yet and the query was solid. It's not an urgent thing as the application is working now but I'm the kind of person that likes to know why something happens rather than just know it happens but have no idea why.

PS. I know one of the if statements checks for a value and the other checks for no value so my THEN statements were switched so the right thing happens so no need to worry about that

[JamieHowarth0]

Hi spoogledrummer,

The reason will probably be because EOF means End Of File i.e. no more records or number of records returned = 0.
The context that you are using it in is If not EOF - i.e. if there are records then do whatever.
This might be causing your "Object required" errors in resulting code:

If Not myRecordset.EOF Then
  'No records found
Else
 'Records found
 '.... subsequent code using myRecordset eg:
Response.Write(myRecordset("Field1"))
End If
 

In the above example, the arguments are the wrong way round for the scenario - i.e. if Not EOF (records found) then perform actions for "no records found" and vice versa. I think that this is maybe what is happening with your code?

Best regards,

medicineworker