[thelist] ASP/TSQL/UID

Chris Marsh chris at webbtech.co.uk
Wed Oct 2 11:43:01 CDT 2002

> >If Not objRS.BOF And objRS.EOF Then
> >	While Not objRS.EOF
> Is there any reason you want to check for BOF here? When
> created the recordset will start at BOF, so if you check for
> NOT BOF, then it will return false. Also, if it's at BOF it
> isn't at EOF, so the second check returns false as well.
> In plain English, the logic you have constructed reads:
> "If Recordset IS NOT at Beginning of File AND IS at End of
> File, then as long as the Recordset IS NOT at End of File..."
> Try eliminating the If statement and see if that helps. The
> While statement will take care of your If check anyway, since
> you want to loop until you hit EOF.

I prefer to practice mental self-flagellation in private, so a simple
thank you must suffice :)


Chris Marsh

More information about the thelist mailing list