Dreamweaver

Display multiple recordset results

The Repeating Region server behavior lets you display multiple records from a recordset within a page. Any dynamic data selection can be turned into a repeating region. However, the most common regions are a table, a table row, or a series of table rows.

  1. In Design view, select a region that contains dynamic content.

    The selection can be anything, including a table, a table row, or even a paragraph of text.

    To select a region on the page precisely, you can use the tag selector on the left corner of the document window. For example, if the region is a table row, click inside the row on the page, then click the rightmost <tr> tag in the tag selector to select the table row.

  2. Select Window > Server Behaviors to display the Server Behaviors panel.
  3. Click the Plus (+) button, and select Repeating Region.
  4. Select the name of the recordset to use from the pop‑up menu.
  5. Select the number of records to display per page, and click OK.

    In the Document window, a thin, tabbed, gray outline appears around the repeating region. In the Live Data window (View > Live Data), the gray outline disappears and the selection expands to display the number of records you specified.

Modify repeating regions in the Property inspector

 Modify the selected repeating region by changing any of the following options:

  • The name of the repeating region.

  • The recordset providing the records for the repeating region.

  • The number of records displayed

    When you select a new option, Dreamweaver updates the page.

Create and add a repeating region to display multiple records on a page

  1. Specify the recordset that contains the data to display in the repeating region.
  2. Specify the number of records to display per page, and click OK.

    If you specify a limited number of records per page and it’s possible the number of records requested might exceed it, add record navigation links to let users display the other records.