Portlet Factory, Version 6.1.2


 

Using the Dynamic Table builder

Use the Dynamic Table builder to give a set of tabular data a visual representation in an HTML page. Typically, the result of a database query yields a set of tabular data. To show the query result in a human-readable form, a Dynamic Table builder can be used.

A Dynamic Table builder accepts two types of source data:

  • A two-dimensional array data structure

  • A ResultSet from a database query

In the case of ResultSet data, the MetaData in the result set defines table schema information (column name, data type, and display label). In the case of simple tabular data, the schema information is calculated using the first row of data. If the table data is sparse (the first row of data does not include all the defined column cells), the table may not display correctly.

 

Display part of a table

Table data does not have to be presented in its entirety. When creating a Dynamic Table builder, you can specify a row index and a row count for displaying a table. This allows you to use a single source of table data and display that data in different ways using multiple tables. This is useful when you need to display table data within a size constraint.

 

Table headers

You can control the display of table headers. The default header display is bold-faced column labels or, if labels are not specified, the column name. You can omit a table header by choosing the Hidden type of header. This is useful when one set of table data is broken into more than one table. You can also use a button or a link control as a table header. For each of these controls you can use an HTML event to define an active function.

Parent topic: Dynamic Table builder


Library | Support |