[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