Looping through a Recordset

In this lesson, you will add Iterator objects to loop through your Recordset and return data. Note that when you use Recordset Iterator objects, you need to add at least 2 on a page - the first to begin the loop and the second to terminate it. If you do not add a terminating iterator, you will receive errors when publishing.

 

  1. Place a Recordset Iterator object on the Home page. This will establish the recordset parameters.
     

          

 

  1. In the Recordset Iterator Properties Editor:
     

    1. Select Start as the object Type.
       

    2. Type ListIterator in the Name field. This will be the name of your Iterator.
       

    3. Type 5 in the RecordsPerPage field. Your contact list will display 5 records at a time.
       

    4. In the Recordset field drop-down, select contacts as the recordset you will be working with.

 

  1. Place an additional Recordset Iterator object below the table and select End as the object Type.