Dreamweaver 8: Building Database Driven Websites

Course Overview

In this course, you'll learn how to connect to a database, search and display results, and build a page to update the database.

Audience

This course is for people new to Dreamweaver (or who have used it only to build static web sites) that want to use it to create data-driven web applications.

Prerequisites

Delegates should be comfortable working with the Windows or Macintosh operating system, be familiar with web terminology and comfortable with what is required to develop a static web application. Delegates also must have completed the Macromedia Dreamweaver 8: Website Development course or have equivalent experience.

Course Outline

Introduction

• Understanding static vs. dynamic pages
• Introducing ColdFusion
• Working with sites in Dreamweaver
• Learning Dreamweaver interface basics
• Developing dynamic pages
• Including common code

Using the Database Panel

• Using databases on the web
• Creating a database connection
• Using the Database panel
• Using the Bindings panel to create a simple recordset
• Creating an advanced recordset using joins

Binding Data to a Page

• Binding data to a page
• Using Live Data View
• Formatting data using the Bindings panel
• Inserting a dynamic image

Customising Recordset Display

• Introducing Server Behaviors
• Displaying all rows in a recordset using Repeat Region
• Introducing Application Objects
• Using the Recordset Navigation Bar to page through recordsets
• Displaying Recordset Navigation Status
• Using the Server Debug View

Creating Drill-down Interfaces

• Creating a drill-down interface
• Generating dynamic links
• Using dynamic filters in SQL
• Using the Dynamic Table Application Object
• Creating a master-detail page set

Creating a Search Interface

• Reviewing HTML Forms
• Creating dynamically populated drop-down menus
• Creating filtered recordsets

Inserting Rows into a Table

• Creating a form and using the Insert Record Server Behavior
• Validating form data using Behaviors
• Creating dynamic form elements
• Using the Recordset Insertion Form Application Object

Updating Rows

• Creating an interface for updating data
• Displaying results in a table using the Dynamic Table Application Object
• Creating a pre-filled form for the row to update
• Using URL parameters
• Using the Record Update Form Application Object
• Manually creating a form and applying an Update Record Server Behavior

Dreamweaver 8: Building Database Driven Websites / CM030972