[thelist] ASP/TSQL/UID

David.Cantrell at Gunter.AF.mil David.Cantrell at Gunter.AF.mil
Wed Oct 2 11:26:00 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


More information about the thelist mailing list