Dreamweaver 8: Cold Fusion Application Development

Request info

Course duration: 2 Days

Cost: £575 + Vat

Introducing the Course

· Understanding the course format
· Reviewing the course objectives and prerequisites
· Looking at the course outline

Getting Started

· 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

Customizing 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
· Using URL parameters
· Using the Record Update Form Application Object
· Manually creating a form and applying an Update Record Server Behavior

SELECT wp_posts.*, wp_p2p.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_p2p WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'start_date' AND CAST(wp_postmeta.meta_value AS DATE) >= '2024-04-24' ) ) AND ((wp_posts.post_type = 'schedule' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) AND (wp_p2p.p2p_type = 'schedule_to_courses' AND wp_posts.ID = wp_p2p.p2p_from AND wp_p2p.p2p_to IN ( SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (170) AND ((wp_posts.post_type = 'courses' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) ORDER BY wp_posts.post_date DESC )) GROUP BY wp_posts.ID ORDER BY CAST(wp_postmeta.meta_value AS DATE) ASC