ASP While Loop conditions

[clintw]

Hi,

I need someone to please clarify the meaning of the following ASP lines. Having trouble following ASP's structure and not finding relevant explanations on web.

1.

While ((Repeat1__numRows <> 0) AND (NOT rsRacers.EOF)) 

What is Repeat1__numRows? I've seen its always initialized to -1 and is added to the row count variable of a resultset. What is the purpose of this variable?

What happens when its not used or included in the While condition?

2.

Repeat1__index=Repeat1__index+1
 Repeat1__numRows=Repeat1__numRows-1

These lines appear inside the while loop. The first line is incremented and isn't used or evaluated. The second line goes back to my first question.

3.
rsRacers.BOF- is it TRUE when there is atleast one record, or when the current row is the first row?
rsRacers.EOF- is it TRUE when there are no more records, or when the current row is the last row?


Excuse this post, if the questions are basic knowledge ;-) Thanks

[JamieHowarth0]

Hi clint,

Yes, your questions are basic but everyone starts somewhere :-).
Each of your questions is answered as follows:

1. Repeat1__numRows appears to be a variable assigned within your program - from the looks of the rest of your code it looks like a decrementing counter (it counts backwards one at a time until it hits zero - it looks like counting how many records are left to process in the recordset). We'd have to see the rest of your code to know for sure though.
   If you remove the Repeat__numRows <> 0 condition from the While statement it shouldn't cause you huge problems (again, subject to checking out your code), as the Not EOF condition is in there to capture the end of recordset.
2. As per question 1.
3. BOF and EOF stand for Beginning Of File and End Of File. BOF is normally used in a recordset where you can move backwards through records as well as forwards.
   BOF will return True when there are no records prior to your current location within the recordset (i.e. in a recordset of 10 records, your "cursor" is pointing at record number 1. If you use the MovePrevious command, the BOF property would return TRUE, as the cursor would be pointing at the Beginning Of the File, not an actual readable record - and the same principle applies with EOF except at the opposite end of the recordset).
   If you have a recordset that contains zero records (no results from query) then BOF and EOF will both equal true.

I hope that this helps.

Best regards,

medicineworker