Why use BOF and EOF

mat41 · July 28th, 2014, 09:11 PM

Hello - I am wanting opinions on why I see this in some places:

Code:

if objRS.EOF AND objRS.BOF then
    no records found do nothing
else
    records found so do stuff
end if

For many many years I have always only ever found the need for this:

Code:

if objRS.EOF  then
    no records found do nothing
else
    records found so do stuff
end if

Is there really any need for the BOF? or is this completely unnecessary like I believe?

TYIA

mmorgan30 · August 3rd, 2014, 01:17 AM

because just testing EOF does not tell you that there were no records in the record set, it just tells that you have reached the end of the record set. if you open a record set that contained no records then both would set.

for the 1st if block testing both does nothing for you as you do "nothing" with the fact you have no records.

for second if block the only thing you have determined is that you have reached the end of the record set.

take a look at this

Code:

if objRS.EOF AND objRS.BOF then
   ''image this logger sends email when error condition arise
   Logger.Error("Error: No records found where we expected records")
else
 ''handle my record 
end if

VS

Code:

if objRS.EOF  then
   ''sending an email here for an empty record set could be a false positive
   '' because just testing EOF means I have reached the end of a record set
   '' not the record set was empty
   Logger.Error("Error: No records found where we expected records")
else
   ''handle my record
end if

mat41 · August 3rd, 2014, 07:44 PM

Hi mmorgan30

Thank you for your time and comments however I have to 100% disagree with all of your comments except one. Yes EOF means end of file and yes BOF is before.......

But im sorry, just testing for EOF does satisfy both effectively when asking if a query returned any results. Just saying IF NOT EOF then do stuff... ELSE dont do stuff... does work every time for me, and has for many mnay years, it continues to work every day as I am still in the classic ASP world full time (believe it or not). Not once has a query ever given me what you call a 'false positive'

Just to clarify my original question was why use BOF and EOF I have only ever used EOF by its self and never hit issues. Is BOF a waste of time and typing?