Show All

Format database results as a table or list

About formatting database results

The Database Results Wizard provides the following formatting options for displaying data in the Database Results region.

Database results formatted as a table, a list, or a drop-down list.

1  An HTML table on a web page displaying information from a record source. One row corresponds to one record. By default, the table column headings correspond to the labels for the record source column headings.

2  A list on a web page displaying three records from a record source. Each row contains the label of the record source column heading followed by the column value. By default, the wizard inserts horizontal lines between records. You can select from a variety of list formats, including bulleted and numbered lists.

3  A drop-down list containing record source column values (for example, beverages, seafood and cereals) and identified by the label of the record source column heading (such as food categories). Using this type of list in a form enables you to efficiently update its values for site visitors.

To format the database results, choose from the following formatting options (start from an open web site, in Page view):

Format database results as a table

  1. Right-click the Database Results region, and then click Database Results Properties. The Database Results Wizard starts. Click Next to get to Step 4.
  2. In Step 4 of the wizard, in the Choose formatting options for the records returned by the query list, click Table - one record per row.
  3. Specify any additional table formatting you want for the Database Results region:

    Hide inside and outside table borders

    Clear the Use table border check box.

    Create a table only as wide as necessary based on its contents

    Clear the Expand table to width of page check box.

    Create a table with no header row identifying the contents of each column

    Clear the Include header row with column labels check box.

Format database results as a list

  1. Right-click the Database Results region, and then click Database Results Properties. The Database Results Wizard starts. Click Next to get to Step 4.
  2. In Step 4 of the wizard, in the Choose formatting options for the records returned by the query list, click List - one field per item.
  3. Specify any additional list formatting options you want, as follows:

  4. In the List options box, select a formatting style for the list, such as Bullet list or Numbered list.

Format database results as a drop-down list

  1. Right-click the Database Results region, and then click Database Results Properties. The Database Results Wizard starts. Click Next to get to Step 4.
  2. In Step 4, in the Choose formatting options for the records returned by the query box, click Drop-down list - one record per item.