Home
Macromedia
Dream Weaver Online Help

Preparing to Build Dynamic Sites

If you’re building a dynamic web application, start by setting up an application server and connecting to a database.

This part contains the following chapters:

Setting Up a Web Application

Database Connections for ColdFusion Developers

Database Connections for ASP.NET Developers

Database Connections for ASP Developers

Database Connections for JSP Developers

Database Connections for PHP Developers

Troubleshooting Database Connections

Getting Started with Dreamweaver

Introduction

What you can do with Dreamweaver 8

What's new in Dreamweaver 8

Installing Dreamweaver 8

Registering Dreamweaver 8

Typographical conventions

Learning Dreamweaver

Where to start

Web-design novices

Experienced web designers

Experienced hand-coders

Web application developers

Getting the most from the Dreamweaver documentation

Using the Dreamweaver help system

Opening Help

Searching help

Using the index

Changing the font size

Using the Start Page

Printing the Dreamweaver Documentation

Discussing the Dreamweaver documentation with LiveDocs

Dreamweaver Basics

Getting to know the Dreamweaver 8 workspace

The Property inspector

The Files panel

The CSS Styles panel

Customizing the Dreamweaver 8 workspace

Choosing the workspace layout (Windows only)

Displaying tabbed documents (Macintosh)

Hiding and displaying the Start page

Accomplishing basic tasks in Dreamweaver 8

About Dreamweaver files

Creating new files in Dreamweaver

Saving files in Dreamweaver

Opening files in Dreamweaver

Tutorial: Setting Up Your Site and Project Files

Learn about Dreamweaver sites

Set up your project files

Define a local folder

Tutorial: Creating a Table-based Page Layout

Examine the design comp

Create and save a new page

Insert tables

Set table properties

Insert an image placeholder

Add color to the page

Tutorial: Adding Content to Pages

Locate your files

Review your task

Insert images

Replace the image placeholder

Insert an image by using the Insert menu

Insert an image by dragging

Insert an image from the Assets panel

Insert and play a Flash file

Insert Flash Video

Insert text

Insert body text

Insert text for a navigation bar

Create links

Preview your page in a browser

Tutorial: Formatting Your Page with CSS

Locate your files

Review your task

Learn about CSS

Create a new style sheet

Attach a style sheet

Explore the CSS Styles panel

Create a new CSS rule

Apply a class style to text

Format the navigation bar text

Create a new rule for the navigation

Apply the rule

Add a rollover effect

(Optional) Center the contents of the page

Tutorial: Publishing Your Site

Learn about remote sites

Define a remote folder

Upload your local files

Troubleshoot the remote folder setup (optional)

Tutorial: Working with Code

Look at the code

Switch to the coding workspace (Windows only)

Add a tag with the Tag Chooser

Edit a tag

Look up information about a tag

Add an image with code hints

Check your changes

Print your code

Tutorial: Creating a CSS-based Page Layout

Learn about CSS-based page layout

Examine the design comp

Create and save a new page

Insert layers

Draw a new layer

Add more layers

Add layers inside a layer

Add color to the page

Tutorial: Displaying XML Data

Locate your files

Review your task

Learn about using XML and XSL with web pages

Learn about XSLT pages

Convert an HTML page to an XSLT page

Attach an XML data source to the XSLT page

Alter the XSLT page layout

Bind XML data to the XSLT page

Apply styles to the XML data

Create a dynamic link

Add a Repeat Region XSLT object

Attach the XSLT page to the XML page

Learn about other deployment options

Tutorial: Developing a Web Application

Before you begin

Review your task

Open a document to work in

Define a recordset

Display the database records

Add dynamic fields to the table

Set a repeated region

View your page

Create a record insert form

Add a Record Insertion Form application object

Create the insert form

Copy files to the server

Related topics

Working with assets

Viewing assets in the Assets panel

Refreshing the Assets panel

Adding an asset to a document

Applying a color to text using the Assets panel

Applying a URL to an image or text using the Assets panel

Selecting and editing assets

Reusing assets in another site

Creating and managing a list of favorite assets

Adding assets to and removing assets from the Favorites list

Creating a nickname for a favorite asset

Grouping assets in a Favorites folder

Working with library items

Creating a library item

Inserting a library item in a document

Editing a library item

Setting library highlighting preferences

Editing the properties for a library item

Making library items editable in a document

Editing a behavior in a library item

Reference

Using the Assets panel

Setting Library item properties

Managing Contribute Sites with Dreamweaver

About managing Contribute sites

Site structure and page design for a Contribute site

Site connection for Contribute compatibility

File transfer to or from a Contribute site

Contribute file and folder permissions on the server

Contribute special files

Preparing a site for use with Contribute

Administering a Contribute site using Dreamweaver

Managing Contribute files using Dreamweaver

Deleting, moving, or renaming a remote file in a Contribute site

Enabling Contribute users to access templates without root folder access

Unlocking a file in a Contribute site

Logging events

Troubleshooting a Contribute site

Troubleshooting connection problems for a Contribute site

Troubleshooting the Contribute administration tools

Reference

Setting options for the Contribute category in the Site Definition dialog box

Laying Out Pages

Laying Out Pages with CSS

About layers in Dreamweaver

Setting layer preferences and properties

Setting layer preferences

Viewing and setting properties for a single layer

Viewing and setting properties for multiple layers

Managing layers

Using the Layers panel

Selecting layers

Changing the stacking order of layers

Changing layer visibility

Converting layers to tables

Preventing layer overlaps

Converting between layers and tables

Animating layers

Using the Timelines panel

Playback options

Moving a layer using a timeline animation

Creating a timeline by dragging a path

Modifying timelines

Changing image and layer properties with timelines

Using multiple timelines

Copying and pasting animations

Applying an animation sequence to a different object

Renaming timelines

Animation tips for timelines

Inserting div tags for layout

Working with div tags for layout

Changing the highlight color for div tags

Working with CSS layout visualization

About CSS layout visualization

Viewing CSS layout blocks

Using Design-time style sheets with CSS layout blocks

Using rulers, guides, and the grid to lay out pages

Using rulers

Using guides

Using the grid

Using a tracing image

Reference

Setting the Insert Div Tag dialog box options

Setting Div tag properties

Setting the Layers Preferences dialog box options

Setting layer properties

Setting properties for multiple layers

Setting the Convert Layers to Table dialog box options

Setting the Convert Tables to Layers dialog box options

Setting the Grid Settings dialog box options

Setting the Guides dialog box options

Presenting Content with Tables

About tables

Table formatting precedence in HTML

About splitting and merging table cells

Inserting a table and adding content

Importing and exporting tabular data

Selecting table elements

Selecting a table

Selecting rows or columns

Selecting cells

Using Expanded Tables mode for easier table editing

Formatting tables and cells

Viewing and setting table, cell, row, and column properties

Editing accessibility attributes for a table

Using a design scheme to format a table

Resizing tables, columns, and rows

Resizing a table

Resizing columns and rows

Making column widths in code consistent with visual widths

Clearing set widths and heights

Displaying table and column widths and menus

Adding and removing rows and columns

Splitting and merging cells

Copying, pasting, and deleting cells

Nesting tables

Sorting tables

Reference

Setting the Table dialog box options

Setting the Import Tabular Data dialog box options

Setting table properties

Setting cell, row, and column properties

Setting the Format Table dialog box options

Setting the Insert Rows or Columns dialog box options

Setting the Split Cell dialog box options

Setting the Sort Table dialog box options

Setting the Export Table dialog box options

Laying Out Pages in Layout Mode

About Layout mode

About viewing table and cell widths in Layout mode

Layout table and cells grid lines

Fixed column width and autostretch columns

Spacer images

Switching from Standard to Layout mode

Drawing in Layout mode

Drawing layout cells and tables

Drawing a nested layout table

Adding content to a layout cell

Clearing automatically set cell heights

Resizing and moving layout cells and tables

Resizing and moving layout cells

Resizing and moving layout tables

Formatting layout cells and tables

Formatting layout cells

Formatting layout tables

Setting column width

Making a column autostretch or fixed-width

Using spacer images

Making column widths in code consistent with visual widths

Setting preferences for Layout mode

Reference

Setting layout cell properties

Setting layout table properties

Setting the Choose Spacer Image dialog box options

Setting the Layout Mode Preferences dialog box options

Using Frames

About frames and framesets

Understanding how frames and framesets work

Deciding whether to use frames

Understanding nested framesets

Working with framesets in the Document window

Creating frames and framesets

Using a predefined frameset

Designing a frameset

Selecting frames and framesets

Selecting frames and framesets in the Frames panel

Selecting frames and framesets in the Document window

Opening a document in a frame

Saving frame and frameset files

Viewing and setting frame properties and attributes

Viewing and setting frameset properties

Controlling frame content with links

Handling browsers that cant display frames

Using JavaScript behaviors with frames

Reference

Setting frame Property inspector options

Setting frameset Property inspector options

Setting the Frame Tag Accessibility Attributes dialog box options

Managing Templates

About Dreamweaver templates

Types of template regions

Templates and template-based documents in Design and Code views

Viewing templates in Design view

Viewing templates in Code view

Viewing template-based documents in Design view

Viewing template-based documents in Code view

Server scripts in templates and template-based documents

Template parameters

Template expressions

The template expression language

The Multiple If condition in template code

Creating a Dreamweaver template

Customizing code coloring preferences for a template

Setting highlighting preferences for template regions

Creating templates for a Contribute site

Creating editable regions

Inserting an editable region

Selecting editable regions

Removing an editable region

Changing an editable regions name

Creating repeating regions

Creating a repeating region in a template

Inserting a repeating table

Setting alternating background colors in a repeating table

Using optional regions

Inserting an optional region

Modifying an optional region

Defining editable tag attributes

Specifying editable tag attributes in a template

Making an editable tag attribute uneditable

Creating a nested template

Editing and updating templates

Opening a template for editing

Manually updating documents that are based on templates

Updating templates in a Contribute site

Checking template syntax

Managing templates

Exporting and importing template XML content

Exporting a site without template markup

Applying or removing a template from an existing document

Applying a template to an existing document

Detaching a document from a template

Editing content in a template-based document

Modifying template properties

Adding, deleting, and changing the order of a repeating region entry

Reference

Setting the Save As Template dialog box options

Setting the New Editable Region dialog box options

Setting the New Repeating Region dialog box options

Setting the Insert Repeating Table dialog box options

Setting the Optional Region dialog box options

Resolving inconsistent region names

Setting options for the Editable Tag Attributes dialog box

Using the Assets panel to manage templates

Setting options for the Update Pages dialog box

Setting the Export Template Data as XML dialog box

Setting options for the Export Site Without Template Markup dialog box

Setting the Template Description dialog box options

Adding Content to Pages

Working with Pages

About working with pages

About setting page properties

About the History panel

About web-safe colors

Understanding document encoding

About using saved commands versus playing back steps

Saving web pages

Specifying HTML instead of CSS

Setting page properties

Changing the document title

Setting CSS link underline styles

Working with colors

Defining default text colors

Selecting elements in the Document window

Showing and hiding invisible elements

Zooming in and out

Using the History panel

Automating tasks

Repeating steps

Applying steps to another object

Applying steps to multiple objects

Copying and pasting steps between documents

Creating new commands from history steps

Recording commands

Using JavaScript behaviors to detect browsers and plug-ins

Previewing and testing pages in browsers

Previewing in a browser

Setting previewing preferences

Previewing active content in Internet Explorer (Windows)

Setting download time and size preferences

Reference

Setting the Page Properties (Document Type) dialog box options

Setting the Title/Encoding Page Properties options

Setting the HTML Appearance Page Properties options

Setting the CSS Appearance Page Properties options

Setting the CSS Links Page Properties options

Setting the CSS Headings Page Properties options

Setting Tracing Image Page Properties options

Setting Invisible Elements preferences

Setting the Preview in Browser Preferences options

Inserting and Formatting Text

About text formatting in Dreamweaver

About inserting text

About formatting text

Understanding Cascading Style Sheets

About conflicting CSS rules

Shorthand CSS properties

The Property inspector and text formatting

About the CSS Styles panel

The CSS Styles panel in Current mode

The CSS Styles panel in All mode

Inserting text

Adding text to a document

Setting copy/paste preferences

Importing tabular data documents

Importing Microsoft Office documents (Windows only)

Inserting a link to a Word or Excel document

Formatting paragraphs and document structure

Formatting paragraphs

Aligning text

Indenting text

Adding paragraph spacing

Using horizontal rules

Creating bulleted and numbered lists

Formatting text

Setting and changing fonts and styles

Renaming a style

Modifying font combinations

Changing the text color

Inserting dates

Inserting special characters

Adding space between characters

Using Cascading Style Sheets to format text

Using the CSS Styles panel

Creating a new CSS rule

Applying a class style

Exporting styles to create a CSS style sheet

Linking to or importing an external CSS style sheet

Using the sample Dreamweaver style sheets

Editing a CSS rule

Editing a CSS style sheet

Updating CSS style sheets in a Contribute site

Using Design-Time style sheets

Checking spelling

Searching for and replacing text

Reference

Setting text property options

Setting List Properties dialog box options

Setting CSS Styles preferences

Defining CSS type properties

Defining CSS style background properties

Defining CSS style block properties

Defining CSS style box properties

Defining CSS style border properties

Defining CSS style list properties

Defining CSS style positioning properties

Defining CSS style extension properties

Setting the Attach External Style Sheet dialog box options

Setting spelling options

Setting the Find and Replace dialog box options

Setting the Find and Replace dialog box options for a specific tag search

Setting the Find and Replace dialog box options for an advanced text search

Setting the Search panel options

Setting the Paste Special dialog box options

Setting the Copy/Paste Preferences dialog box

Setting the Insert Document dialog box options

Setting the Rename Class or Rename Style dialog box options

Inserting Images

About images

Editing images in Dreamweaver

Inserting an image

Inserting an image placeholder

Aligning an image

Resizing an image

Cropping an image

Optimizing an image using Fireworks

Adjusting the brightness and contrast of an image

Sharpening an image

Creating a rollover image

Using an external image editor

Applying behaviors to images

Reference

Setting image properties

Setting the Image Tag Accessibility Attributes dialog box options

Setting the Image Description dialog box options

Completing the Image Placeholder dialog box

Setting image placeholder properties

Setting external image editor preferences

Setting the Image Rollover dialog box options

Setting the Brightness and Contrast dialog box options

Setting the Sharpen Image dialog box options

Linking and Navigation

Understanding document locations and paths

Absolute paths

Document-relative paths

Site root-relative paths

Linking files and documents

Linking to documents using the Property inspector

Linking documents using the Point-to-File icon

Linking documents using the site map

Using the Hyperlink command

Setting the relative path of new links

Linking to a specific place in a document

Managing links

Changing a link sitewide

Inserting jump menus

Using navigation bars

Using image maps

Attaching JavaScript behaviors to links

Checking for broken, external, and orphaned links

Fixing broken links

Opening linked documents in Dreamweaver

Reference

Setting the Named Anchor option

Setting hyperlink options

Setting E-mail Link options

Setting the Change Link Sitewide options

Setting Insert Jump Menu options

Setting Navigation Bar options

Setting the Hotspot Property inspector options

Working with Other Applications

About Fireworks and Flash integration

Optimizing your work environment for Fireworks and Flash

Working with Fireworks

Inserting a Fireworks image

Editing a Fireworks image or table from Dreamweaver

Optimizing a Fireworks image from Dreamweaver

Using Fireworks to modify Dreamweaver image placeholders

Editing Fireworks pop-up menus in Dreamweaver

Specifying launch-and-edit preferences for Fireworks source files

Inserting Fireworks HTML code in a Dreamweaver document

Pasting Fireworks HTML into Dreamweaver

Updating Fireworks HTML placed in Dreamweaver

Creating a web photo album

Working with Flash

Editing Flash content in Dreamweaver

Adding Audio, Video, and Interactive Elements

About media files

About Flash file types

About audio file formats

Inserting and editing media objects

Editing accessibility attributes for media objects

Starting an external editor for media files

Specifying the editor to start from Dreamweaver

Using Design Notes with media objects

Inserting and modifying a Flash button object

Creating and inserting a Flash button

Modifying a Flash button object

Playing a Flash button object in the document

Inserting a Flash text object

Inserting Flash content

Downloading and installing Flash elements

Inserting Flash elements

Editing Flash element attributes

Inserting FlashPaper documents

Inserting Flash Video content

About inserting Flash Video

Inserting a Flash Video

Detecting the Flash Player version to view the Flash Video

Editing and deleting a Flash Video component

Inserting Shockwave movies

Adding video (non-Flash)

Adding sound to a page

Embedding a sound file

Inserting Netscape Navigator plug-in content

Inserting plug-in content in your page

Playing plug-ins in the Document window

Troubleshooting Netscape Navigator plug-ins

Inserting an ActiveX control

Inserting a Java applet

Using behaviors to control media

Reference

Setting Flash object properties

Using parameters to control media objects

Setting the Insert Flash Video dialog box options

Setting Flash and Shockwave movie properties

Setting Netscape Navigator plug-in properties

Setting ActiveX properties

Setting Java applet properties

Setting the Object Tag Accessibility Attributes dialog box options

Setting the Insert Flash Button dialog box options

Setting the Flash element inspector

Setting the Flash element Edit Array dialog box options

Using JavaScript Behaviors

Using the Behaviors panel

About events

Applying a behavior

Attaching a behavior to text

Changing a behavior

Updating a behavior

Creating new actions

Downloading and installing third-party behaviors

Using the behavior actions that come with Dreamweaver

Control Shockwave or Flash

Drag Layer

Gathering information about the draggable layer

Set Text of Status Bar

Set Text of Text Field

Show-Hide Layers

Show Pop-Up Menu

Adding, removing, and changing the order of pop-up menu items

Setting the appearance of a pop-up menu

Setting advanced appearance options

Setting a pop-up menus position in a document

Modifying a pop-up menu

Setting the Behaviors panel options

About Fireworks 8 pop-up menus

Working with Page Code

Setting Up Your Coding Environment

Viewing your code

Using the coder-oriented workspace (Windows only)

Setting coding preferences

Setting code viewing options

Setting code formatting preferences

Applying new formatting preferences to existing documents

Setting code hints preferences

Setting code rewriting preferences

Setting code coloring preferences

Customizing keyboard shortcuts

Opening files in Code view by default

Setting Validator preferences

Managing tag libraries

Opening and closing the Tag Library editor

Adding libraries, tags, and attributes

Editing libraries, tags, and attributes

Deleting libraries, tags, and attributes

Importing custom tags into Dreamweaver

Importing tags from XML files

Importing custom ASP.NET tags

Importing JSP tags from a file

Importing JSP tags from a server (web.xml)

Importing JRun tags

Using an external HTML editor with Dreamweaver

Using an integrated HTML editor

Using HomeSite (Windows only)

Using BBEdit (Macintosh only)

Setting file type and external editor preferences

Reference

Setting the Tag Library editor dialog box options

Setting the code format preference options

Setting the code hints preference options

Setting the code rewriting preference options

Setting the code coloring preference options

Setting the Validator preference options

Setting the New Tags dialog box options

Setting the New Attributes dialog box options

Setting the JSP tag library Import from File dialog box options

Setting the JSP tag library Import from Server dialog box options

Setting the Import JRun Server Tags from Folder dialog box options

Setting the File Types/Editors preference options

Setting the Code inspector options

Coding in Dreamweaver

About coding in Dreamweaver

Supported languages

About fixing invalid markup

Automatic code modification in Dreamweaver

About the XHTML code generated by Dreamweaver

Server-side includes

Regular expressions

About server behavior code

Writing and editing code

Using code hints

Working with code snippets

Inserting code quickly with the Coding toolbar

Inserting code quickly with the Insert bar

Inserting tags with the Tag Chooser

Editing tags with Tag editors

Collapsing code

About collapsing code

Collapsing and expanding code fragments

Pasting and moving collapsed code fragments

Indenting code blocks

Copying and pasting code

Inserting HTML comments

Jumping to a JavaScript or VBScript function

Searching and replacing tags and attributes

Searching for tags, attributes, or text contained in specific tags

Saving search patterns

Making quick changes to a code selection

Using language-reference material

Printing your code

Reference

Setting the Snippets dialog box options

Setting the Comment dialog box options

Setting the comment Property inspector options

Setting the Tag Chooser dialog box options

Optimizing and Debugging Your Code

Cleaning up your code

Verifying that tags and braces are balanced

Checking for browser compatibility

Validating your tags

Making pages XHTML-compliant

Using the ColdFusion debugger (Windows only)

Reference

Setting the Clean Up HTML dialog box options

Editing Code in Design View

Editing code with the Property inspector

Changing attributes with the Tag inspector

Editing code with the Quick Tag Editor

Inserting an HTML tag with the Quick Tag Editor

Editing an HTML tag with the Quick Tag Editor

Applying HTML to a selection with the Quick Tag Editor

Using the hints menu in the Quick Tag Editor

Editing code with the tag selector

Editing scripts

Writing a client-side script in Design view

Linking to an external script file

Editing a script in Design view

Working with server-side includes

Inserting a server-side include

Editing the contents of a server-side include

Using JavaScript behaviors

Viewing and editing head content

Reference

Setting the Quick Tag Editor options

Setting the Script dialog box options

Setting the Script Properties dialog box options

Setting the script Property inspector options

Setting the server-side include Property inspector options

Setting the ColdFusion tag Property inspector options

Setting the ASP script Property inspector options

Setting Meta properties

Setting Title properties

Setting Keywords properties

Setting Description properties

Setting Refresh properties

Setting Base properties

Setting properties for the link tag

Setting code properties

Using the Select Child command

Preparing to Build Dynamic Sites

Setting Up a Web Application

What you need to build web applications

Setting up a web server

Setting up an application server

Choosing your application server

Installing a ColdFusion application server

Installing an ASP.NET application server

Installing an ASP application server

Installing a JSP application server

Installing a PHP application server

Creating a root folder for the application

Defining a Dreamweaver site

Defining a local folder

Defining a remote folder

Specifying where dynamic pages can be processed

Connecting to a database

Reference

Setting the Testing Server category options

Setting the URL prefix

Database Connections for ColdFusion Developers

Connecting to a database

Creating or modifying a ColdFusion data source

Connecting to the database in Dreamweaver

Editing or deleting a database connection

Reference

Setting the Connection dialog box options (ColdFusion)

Database Connections for ASP.NET Developers

Connecting to a database

Obtaining an OLE DB provider for your database

Creating an ASP.NET database connection in Dreamweaver

Creating a connection using Data Link Properties

Sample OLE DB connection parameters for ASP.NET

Editing or deleting a database connection

Reference

Setting the OLE DB Connection dialog box options

Setting the Connection String Template dialog box options

Setting the SQL Server Connection dialog box options

Database Connections for ASP Developers

About database connections in ASP

ASP database connections

OLE DB connections

Creating a DSN connection

Creating a connection using a local DSN

Creating a DSN-less connection

Connecting to a database on an ISP

Understanding physical and virtual paths

Finding a files physical path with the virtual path

Using a virtual path to connect to a database

Editing or deleting a database connection

Reference

Setting the Data Source Name (DSN) dialog box options

Setting the Select ODBC DSN dialog box options

Setting the Custom Connection String dialog box options

Setting the Connection String option

Setting the Connections dialog box options

Using the Remove Connection Scripts command

Database Connections for JSP Developers

About database connections in JSP

JSP connections

JDBC connection parameters

Connecting to a database

Connecting through an ODBC driver

Editing or deleting a database connection

Reference

Setting JSP connection dialog box options

Database Connections for PHP Developers

Connecting to a database

Editing or deleting a database connection

Reference

Setting the MySQL Connection dialog box options

Setting the Select Database dialog box options

Troubleshooting Database Connections

Troubleshooting permissions problems

Troubleshooting Microsoft error messages

80004005--Data source name not found and no default driver specified

80004005--Couldnt use (unknown); file already in use

80004005--Logon Failed()

80004005--Operation must use an updateable query

80040e07--Data type mismatch in criteria expression

80040e10--Too few parameters

80040e10--COUNT field incorrect

80040e14--Syntax error in INSERT INTO statement

80040e21--ODBC error on Insert or Update

800a0bcd--Either BOF or EOF is true

Troubleshooting MySQL error messages

Making Pages Dynamic

Optimizing the Workspace for Visual Development

Displaying web-application development panels

Viewing your database within Dreamweaver

Viewing live data in Design view

Requirements for displaying live data

Copying dependent files

Refreshing the page

Working in Design view without live data

Previewing dynamic pages in a browser

Restricting database information displayed in Dreamweaver

Reference

Setting the Bindings panel options

Setting the Server Behaviors panel options

Setting the Databases panel options

Setting the Components panel options

Setting the Live Data Settings dialog box options

Setting the Restrict dialog box options

The Workflow for Dynamic Page Design

Designing the page

Creating a source of dynamic content

Adding dynamic content to a web page

Enhancing the functionality of a dynamic page

Adding server behaviors to a page

Testing and debugging the page

Testing dynamic content

Editing dynamic content on a page

Deleting dynamic content

Obtaining Data for Your Page

Using a database to store content

Accessing data stored in a database

Collecting data submitted by users

Form parameters

URL parameters

Creating URL parameters using HTML links

Retrieving form and URL parameters

Accessing data stored in session variables

Understanding session variables

Collecting information to store in session variables

Storing URL parameters in session variables

Storing form parameters in session variables

Storing information in session variables

Example of information stored in session variables

Retrieving data from session variables

Defining Sources of Dynamic Content

About dynamic content sources

Understanding recordsets

Understanding URL and form parameters

About session variables

ASP and ColdFusion application variables

ASP server variables

ColdFusion server variables

Defining a recordset

Creating a recordset without writing SQL

Creating an advanced recordset by writing SQL

Creating SQL queries using the Database Items tree

Selecting a table

Selecting specific rows from a table and ordering the results

Defining URL parameters

Defining form parameters

Defining session variables

Defining application variables for ASP and ColdFusion

Using a variable as a data source for a ColdFusion recordset

Defining server variables

Defining ASP server variables

Defining ColdFusion server variables

Defining PHP server variables

Defining JSP server variables

Caching content sources

Changing or deleting content sources

Copying a recordset from one page to another page

Reference

Setting the Bindings panel options

Setting the simple Recordset dialog box options

Setting the simple Recordset dialog box options (ColdFusion)

Setting the simple DataSet dialog box options (ASP.NET)

Setting the advanced Recordset dialog box

Setting the advanced Recordset dialog box (ASP.NET)

Setting the advanced Recordset dialog box options (ColdFusion)

Setting the Request Variable dialog box options (ASP)

Setting the Add Parameter dialog box options

Setting the Add Parameter dialog box options (PHP)

Setting the Request Variable dialog box options (JSP)

Setting the Session Variable dialog box options

Setting the Application Variable dialog box options

Setting the URL Variable dialog box options (ColdFusion)

Setting the Form Variable dialog box options (ColdFusion)

Setting the Client Variable dialog box options (ColdFusion)

Setting the Cookie Variable dialog box options

Setting the CGI Variable dialog box options

Setting the Server Variable dialog box options

Setting the Local Variable dialog box options

Adding Dynamic Content to Web Pages

About adding dynamic content

Dynamic text

Changing dynamic content

Making text dynamic

Making images dynamic

Making HTML attributes dynamic

Making ActiveX, Flash, and other object parameters dynamic

Editing dynamic content

Deleting dynamic content

Creating dynamic pages in a Contribute site

Reference

Setting the Dynamic Text dialog box options

Setting the Dynamic Data dialog box options

Setting the Property inspector for recordsets

Setting the Property inspector for ColdFusion stored procedures, ASP commands, and JSP callables

Setting the Property inspector for JSP prepared statements

Setting the Property inspector for repeated regions

Displaying Database Records

About displaying database records

Server behaviors and formatting elements

Applying typographic and page layout elements to dynamic data

Navigating database recordset results

Custom recordset navigation bars

Navigation bar design tasks

Displaying and hiding regions based on recordset results

Displaying multiple recordset results

Record counters

Using predefined data formats

Customizing existing data formats

Creating new data formats

Creating recordset navigation links

Creating a navigation bar using the Recordset Navigation Bar server behavior

Creating a custom recordset navigation bar

Showing and hiding regions based on recordset results

Displaying multiple recordset results

Creating a table with a Repeat Region server behavior

Creating a record counter

Creating a record counter using the Recordset Navigation Status object

Creating custom record counters

Reference

Setting the Insert Recordset Navigation Bar dialog box options

Setting the Move To (server behavior) dialog box options

Setting the Repeat Region dialog box options

Setting the Insert Recordset Navigation Status dialog box options

Setting the Edit Format List dialog box options

Setting the Currency, Number, or Percent dialog box options

Setting the Display Current Page Number dialog box options

Displaying XML Data in Web Pages

About using XML and XSL with web pages

About server-side XSL transformations

About client-side XSL transformations

About XML data and repeating elements

About previewing XML data

Performing XSL transformations on the server

Workflow for performing server-side XSL transformations

Creating XSLT pages

Converting HTML pages to XSLT pages

Attaching XML data sources

Displaying XML data in XSLT pages

Displaying repeating XML elements

Editing a Repeat Region XSLT object

Inserting XSLT fragments in dynamic pages

Deleting XSLT fragments from dynamic pages

Editing XSL Transformation server behaviors

Using parameters with XSL transformations

Creating conditional XSLT regions

Editing a Conditional Region XSLT object

Inserting XSL comments

Performing XSL transformations on the client

Workflow for performing client-side XSL transformations

Creating entire XSLT pages

Linking XSLT and XML files

Applying styles to XSLT fragments

Troubleshooting XSL transformations

Reference

Setting the Locate XML Source dialog box options

Setting the Attach an XSLT Stylesheet dialog box options

Setting XPath Expression Builder (Dynamic Text) dialog box options

Setting the XPath Expression Builder (Repeat Region) dialog box options

Setting the Conditional Region dialog box options

Setting the Multiple Conditional Region dialog box options

Setting Repeat Region (XSL) properties

Setting Conditional Region (If) properties

Setting Conditional Region (When) properties

Specifying a missing character entity

Using Web Services

About web services

The Dreamweaver web service workflow

Finding web service publishers

Web service software components

Web service references

About proxy generators

Obtaining additional proxy generators

Configuring proxy generators for use with Dreamweaver

Adding a web service proxy using the WSDL description

Adding a web service to a page

Editing the UDDI web service site list

Reference

Setting the Web Services Chooser dialog box options

Setting the Proxy Generators dialog box options

Setting the Default Proxy Generator dialog box options

Setting the Select Server Model dialog box options

Setting the UDDI Site dialog box options

ColdFusion Proxy Generator dialog box

Setting the Add Using Proxy Classes dialog box

Adding Custom Server Behaviors

About custom server behaviors

Server behaviors

About code blocks

Parameters in server behaviors

Making code blocks conditional

Effectively using conditional expressions

Repeating code blocks

Using the loop directives _length and _index variables

Coding guidelines

Testing server behaviors

Installing third-party server behaviors

Using the Server Behavior Builder

Using parameters in server behaviors

Positioning code blocks

Creating a dialog box for a custom server behavior

Editing and modifying server behaviors

Reference

Setting the New Server Behavior dialog box options

Setting the Server Behavior Builder dialog box options

Setting the Insert Parameter in Code Block dialog box options

Setting the Create a New Code Block dialog box options

Setting the Generate Behavior Dialog Box dialog box options

Setting the Edit Server Behaviors dialog box options

Creating Forms

About forms

Client-side role of forms

Form objects

Dynamic form objects

Creating HTML forms

Inserting HTML form objects

Inserting HTML text fields

Inserting HTML checkboxes

Inserting HTML radio buttons

Inserting HTML form menus

Inserting standard buttons

Inserting image buttons

Inserting hidden fields

Inserting file-upload fields

Inserting dynamic HTML form objects

Creating a dynamic HTML form menu

Making existing HTML form menus dynamic

Displaying dynamic content in HTML text fields

Dynamically preselecting HTML checkboxes

Dynamically preselecting HTML radio buttons

Validating HTML form data

Attaching JavaScript behaviors to HTML form objects

Attaching custom scripts to HTML form buttons

Creating accessible HTML forms

Reference

Setting form properties

Setting text field properties

Setting checkbox properties

Setting radio button properties

Setting menu properties

Setting button properties

Setting image field properties

Setting hidden field properties

Setting file field properties

Setting Input Name properties

Setting the Input Tag Accessibility Attributes dialog box options

Setting the Radio Group dialog box options

Setting the Dynamic Radio Group dialog box options (ColdFusion, ASP.NET)

Setting the Dynamic Radio Group dialog box options

Setting the Dynamic Text Field dialog box options

Setting the Dynamic CheckBox dialog box options

Setting the Dynamic List/Menu dialog box options

Setting the List Values dialog box options

Developing Applications Rapidly

Building ColdFusion Applications Rapidly

About rapid application development (all servers)

About master/detail pages

About search/results pages

About advanced database manipulation objects

Stored procedures

ASP command objects

JSP prepared statements

Building ColdFusion MX 7 forms

Enabling the ColdFusion enhancements

Creating ColdFusion forms

Inserting ColdFusion form controls

Inserting ColdFusion text fields

Inserting ColdFusion hidden fields

Inserting ColdFusion text areas

Inserting ColdFusion buttons

Inserting ColdFusion checkboxes

Inserting ColdFusion radio buttons

Inserting ColdFusion select boxes

Inserting ColdFusion image fields

Inserting ColdFusion file fields

Inserting ColdFusion date fields

Setting the properties of ColdFusion form controls visually

Validating ColdFusion form data

Building master/detail pages (ColdFusion)

Building master/detail pages in one operation (ColdFusion, ASP, JSP, PHP)

Building master/detail pages block by block (ColdFusion)

Creating the master page (ColdFusion)

Creating the links to the detail page (ColdFusion)

Creating a URL parameter for the links (ColdFusion)

Finding and displaying the requested record on the detail page (ColdFusion)

Building search/results pages (ColdFusion, ASP, JSP, PHP)

Building the search page

Building the results page

Searching with only one search parameter

Searching with multiple search parameters

Displaying the results

Creating a detail page for a results page

Building a record insert page (all servers)

Building the insert page in one operation

Building an insert page block by block

Building pages to update a record (ColdFusion)

Searching for the record to update (ColdFusion)

Creating the links to open the update page (ColdFusion)

Creating a URL parameter for update links (ColdFusion)

Retrieving the record to update (ColdFusion)

Completing the update page in one operation (ColdFusion)

Completing the update page block by block (ColdFusion)

Building pages to delete a record (ColdFusion)

Searching for the record to delete (ColdFusion)

Creating links to a confirmation page (ColdFusion)

Creating a URL parameter to pass to the confirmation page (ColdFusion)

Displaying the record on the confirmation page (ColdFusion)

Adding logic to delete the record (ColdFusion)

Using stored procedures to modify databases (ColdFusion)

Building pages that restrict access to your site (ColdFusion, ASP, JSP, PHP)

Building a registration page

Storing login information about users

Letting users choose a user name and password

Updating the table of users in the database

Making sure the chosen user name is unique

Building a login page

Creating a database table of registered users

Letting users log in

Checking the user name and password

Building a page only authorized users can access

Redirecting unauthorized users to another page

Storing access privileges in the user database

Logging out users

Securing a folder in your application (ColdFusion)

Using ColdFusion components

About ColdFusion components

Visually creating a component in Dreamweaver

Viewing ColdFusion components in Dreamweaver

Editing ColdFusion components in Dreamweaver

Building web pages that use ColdFusion components

Defining a recordset in a ColdFusion component

Using a CFC recordset as a source of dynamic content

Reference

Setting CFForm properties (ColdFusion)

Setting CFTextField properties (ColdFusion)

Setting CFHiddenField properties (ColdFusion)

Setting CFTextArea properties (ColdFusion)

Setting CFButton properties (ColdFusion)

Setting CFCheckBox properties (ColdFusion)

Setting CFRadioButton properties (ColdFusion)

Setting CFSelect properties (ColdFusion)

Setting CFImageField properties (ColdFusion)

Setting CFFileField properties (ColdFusion)

Setting CFDateField properties (ColdFusion)

Setting the Master Detail Page Set dialog box options

Setting the Record Insertion Form dialog box options

Setting the Form Element Properties dialog box options

Setting the Insert Record dialog box options (ASP & JSP)

Setting the Insert Record dialog box options (PHP)

Setting the Insert Record dialog box options (ColdFusion)

Setting the Insert Record dialog box options (ASP.NET)

Setting the Record Update Form dialog box options

Setting the Update Record dialog box options (ColdFusion)

Setting the Delete Record dialog box options (ColdFusion)

Setting the ColdFusion Stored Procedure dialog box options

Setting the Stored Procedure Variable dialog box options

Setting the Check New Username dialog box options

Setting the Log In User dialog box options

Setting the Restrict Access To Page dialog box options

Setting the Define Access Levels dialog box options

Setting the Log Out User dialog box options

Setting the ColdFusion Login Wizard options

Setting the Create Component dialog box options

Setting the CF Components panel options

Setting the CFC Query dialog box options

Setting the New Component dialog box options

Setting the Edit Parameter dialog box options

Building ASP.NET Applications Rapidly

Building ASP.NET forms

Adding ASP.NET form controls to a page

Setting the properties of ASP.NET form controls

Creating a dynamic ASP.NET menu

Making an existing ASP.NET menu dynamic

Displaying dynamic content in an ASP.NET TextBox control

Dynamically preselecting ASP.NET CheckBox controls

Dynamically preselecting an item in an ASP.NET RadioButtonList

Creating ASP.NET DataGrid and DataList web controls

About the ASP.NET DataGrid and DataList controls

Adding an ASP.NET DataGrid to a page

Adding an ASP.NET DataList to your page

Modifying a DataGrid or DataList object

Building master/detail pages (ASP.NET)

Creating the master page (ASP.NET)

Opening a detail page and passing a record ID (ASP.NET)

Finding and displaying the requested record on the detail page (ASP.NET)

Building a database search page (ASP.NET)

Adding the search controls (ASP.NET)

Searching with only one search parameter (ASP.NET)

Searching with multiple search parameters (ASP.NET)

Displaying the results in a DataGrid

Hiding the DataGrid the first time the page loads

Creating a detail page (ASP.NET)

Building a record insert page (ASP.NET)

Building pages to update a record (ASP.NET)

Searching for the record to update (ASP.NET)

Opening the update page and passing the record ID (ASP.NET)

Retrieving the record to update (ASP.NET)

Completing the update page in one operation (ASP.NET)

Completing the update page block by block (ASP.NET)

Building pages to delete a record (ASP.NET)

Searching for the record to delete (ASP.NET)

Creating delete links on the search page (ASP.NET)

Displaying the record on the confirmation page (ASP.NET)

Adding logic to delete the record (ASP.NET)

Using stored procedures to modify databases (ASP.NET)

Building pages that restrict access to your site (ASP.NET)

Reference

Setting the asp:Button dialog box options

Setting the asp:CheckBox dialog box options

Setting the asp:ImageButton dialog box options

Setting the asp:Label dialog box options

Setting the asp:RadioButton dialog box options

Setting the asp:TextBox dialog box options

Setting the asp:CheckBoxList dialog box options

Setting the asp:DropDownList dialog box options

Setting the asp:ListBox dialog box options

Setting the asp:RadioButtonList dialog box options

Setting Button properties (ASP.NET)

Setting CheckBox properties (ASP.NET)

Setting ImageButton properties (ASP.NET)

Setting Label properties (ASP.NET)

Setting RadioButton properties (ASP.NET)

Setting TextBox properties (ASP.NET)

Setting CheckBoxList properties (ASP.NET)

Setting DropDownList properties (ASP.NET)

Setting ListBox properties (ASP.NET)

Setting RadioButtonList properties (ASP.NET)

Setting the List Items dialog box options

Setting the ASP.NET DataGrid Object dialog box options

Setting the Simple Data Field dialog box options

Setting the Free Form dialog box options

Setting the Hyperlink Column dialog box options

Setting the Edit, Update, Cancel Buttons dialog box options

Setting the Delete Button dialog box options

Setting the ASP.NET DataList Object dialog box options

Setting the Add Data Field dialog box options

Setting the ASP.NET DataGrid Property inspector options

Setting the ASP.NET DataList Property inspector options

Setting the Record Update Form dialog box options (ASP.NET)

Setting the Update Record dialog box options (ASP.NET)

Setting the Delete Record dialog box options (ASP.NET)

Setting the Stored Procedure dialog box options (ASP.NET)

Setting the Edit Stored Procedure Variable dialog box options (ASP.NET)

Setting the Build Value dialog box options (ASP.NET)

Building ASP and JSP Applications Rapidly

Building master/detail pages (ASP and JSP)

Building master/detail pages in one operation (ASP and JSP)

Building master/detail pages block by block (ASP and JSP)

Creating a master page and defining a recordset for it (ASP and JSP)

Displaying the records on the master page (ASP and JSP)

Opening the detail page and passing a record ID to it (ASP and JSP)

Finding and displaying the requested record on the detail page (ASP and JSP)

Building search/results pages (ASP and JSP)

Building a record insert page (ASP and JSP)

Building pages to update a record (ASP and JSP)

Searching for the record to update (ASP and JSP)

Opening the update page and passing the record ID (ASP and JSP)

Retrieving the record to update (ASP and JSP)

Completing the update page in one operation (ASP and JSP)

Completing the update page block by block (ASP and JSP)

Building pages to delete a record (ASP and JSP)

Identifying the record to delete (ASP and JSP)

Retrieving the record to delete (ASP and JSP)

Displaying the data to be deleted (ASP and JSP)

Sending the delete command to the server (ASP and JSP)

Deleting the record from the database table (ASP and JSP)

Building pages with advanced data manipulation objects (ASP and JSP)

Using stored procedures to modify databases (ASP and JSP)

Running a stored procedure (ASP)

Running a stored procedure (JSP)

Using ASP commands to modify a database

Using JSP prepared statements to modify a database

Building pages that restrict access to your site (ASP and JSP)

Using JavaBeans (JSP)

Reference

Setting the Go to Detail Page dialog box options (ASP and JSP)

Setting the Move To Specific Record dialog box options (ASP and JSP)

Setting the Go To Related Page dialog box options (ASP and JSP)

Setting the Update Record dialog box options (ASP and JSP)

Setting the Delete Record dialog box options (ASP and JSP)

Setting the Command (Stored Procedure) dialog box options

Setting the Callable (Stored Procedure) dialog box options

Setting the Prepared (Insert, Update, Delete) dialog box options (JSP)

Setting the JavaBean dialog box options

Setting the JavaBean Collection dialog box options

Building PHP Applications Rapidly

Building master/detail pages (PHP)

Building master/detail pages in one operation (PHP)

Building master/detail pages block by block (PHP)

Creating the master page (PHP)

Creating the links to the detail page (PHP)

Creating a URL parameter for the links (PHP)

Finding and displaying the requested record on the detail page (PHP)

Building search/results pages (PHP)

Building a record insert page (PHP)

Building pages to update a record (PHP)

Searching for the record to update (PHP)

Creating the links to open the update page (PHP)

Creating a URL parameter for update links (PHP)

Retrieving the record to update (PHP)

Completing the update page in one operation (PHP)

Completing the update page block by block (PHP)

Building pages to delete a record (PHP)

Searching for the record to delete (PHP)

Creating links to a confirmation page (PHP)

Creating a URL parameter to pass to the confirmation page (PHP)

Displaying the record on the confirmation page (PHP)

Adding logic to delete the record (PHP)

Building pages that restrict access to your site (PHP)

Reference

Setting the Update Record dialog box options (PHP)

Setting the Delete Record dialog box options (PHP)

Appendixes

Beginners Guide to Databases

About databases

Database design basics

Studying Arrow Aircrafts business rules and policies

Studying Arrow Aircrafts feature request

What questions will users ask the database?

Choosing the tables that belong in the database

Choosing the columns in each table

Defining relationships between the tables

Creating the database

Understanding database connections

Communicating with the database

Using database drivers to communicate with your database

Viewing the ODBC drivers installed on a Windows system

Invoking database drivers

Using a DSN

SQL Primer

Syntax basics

Defining the columns of a recordset

Limiting the records in a recordset

Sorting the records in a recordset

Joining tables