Adobe Dreamweaver CC 2014 v.13 - Manual (Page 241)

Displaying database records
To the top
To the top
To the top
To the top
About database records
Server behaviors and formatting elements
Applying typographic and page layout elements to dynamic data
Navigating database recordset results
Create a recordset navigation bar
Custom recordset navigation bars
Navigation bar design tasks
Display and hide regions based on recordset results
Display multiple recordset results
Create a dynamic table
Create record counters
Use predefined data formats
Note: The user interface has been simplified in Dreamweaver CC and later. As a result, you may not find some of the options described in this
article in Dreamweaver CC and later. For more information, see
this article .
About database records
Displaying database records involves retrieving information stored in a database or other source of content, and rendering that information to a
web page. Dreamweaver provides many methods of displaying dynamic content, and provides several built-in server behaviors that let you both
enhance the presentation of dynamic content, and allow users to more easily search through and navigate information returned from a database.
Databases and other sources of dynamic content provide you with more power and flexibility in searching, sorting, and viewing large stores of
information. Using a database to store content for websites makes sense when you need to store large amounts of information, and then retrieve
and display that information in a meaningful way. Dreamweaver provides you with several tools and prebuilt behaviors to help you effectively
retrieve and display information stored in a database.
Server behaviors and formatting elements
Dreamweaver provides the following server behaviors and formatting elements to let you enhance the display of dynamic data:
Formats let you apply different types of numerical, monetary, date/time, and percentage values to dynamic text.
For example, if the price of an item in a recordset reads 10.989, you can display the price on the page as $10.99 by selecting the Dreamweaver
“Currency - 2 Decimal Places” format. This format displays a number using two decimal places. If the number has more than two decimal places,
the data format rounds the number to the closest decimal. If the number has no decimal places, the data format adds a decimal point and two
zeros.
Repeating Region server behaviors let you display multiple items returned from a database query, and let you specify the number of records to
display per page.
Recordset Navigation server behaviors let you insert navigation elements that allow users to move to the next or previous set of records returned
by the recordset. For example, if you choose to display 10 records per page using the Repeating Region server object, and the recordset returns
40 records, you can navigate through 10 records at a time.
Recordset Status Bar server behaviors let you include a counter that shows users where they are within a set of records relative to the total
number of records returned.
Show Region server behaviors let you choose to show or hide items on the page based on the relevance of the currently displayed records. For
example, if a user has navigated to the last record in a recordset, you can hide the Next link, and display only the Previous records link.
Applying typographic and page layout elements to dynamic data
A powerful feature of Dreamweaver is the ability to present dynamic data within a structured page, and to apply typographic formatting using
HTML and CSS. To apply formats to dynamic data in Dreamweaver, format the tables and placeholders for the dynamic data using the
Dreamweaver formatting tools. When the data is inserted from its data source, it automatically adopts the font, paragraph, and table formatting you
specified.
Navigating database recordset results
Recordset navigation links let users move from one record to the next, or from one set of records to the next. For example, after designing a page
234