[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 :)
Regards
Chris Marsh
More information about the thelist
mailing list