This is the second course in a series of tutorials from the Virtual Training Company for Dreamweaver MX. It covers all that techniques required to construct a data driven web site. Author Mark Fletcher (a Certified Macromedia Professional and member of Team Macromedia) will teach you how to construct a database, create database queries using SQL (Structure Query Language) and how to connect to a database using IIS (Internet Information Server), PWS (Personal Web Server) and the Macromedia ColdFusion MX Server using both a PC and Macintosh. Mark also guides you through building dynamic pages using Macromedia's Live Object and Server Behaviors with ASP, ASP.NET and ColdFusion MX. To start, simply click one of the topics below.
Try For Free Right Now To help you evaluate this training program, some of the tutorials may be viewed for free online. Listed below are all of the chapters and lessons for this title. Click on any of the linked lessons below to watch them now online!
Creating a Connection in Cold Fusion MX to a MS SQL Server
(01:36)
Connecting a Macintosh to a Windows 2000 Server
(02:54)
Connecting from Mac OS9 to a Shared Windows Folder
(01:22)
Connecting from Mac OSX to a Shared Windows Folder (1)
(01:16)
Connecting from Mac OSX to a Shared Windows Folder (2)
(02:26)
Creating a Site
Defining a Site for ASP
(04:12)
Defining a Site for CFM
(04:16)
Defining a Site for ASP.NET
(03:08)
Deploying Supporting File - ASP.NET
(01:09)
Connecting to an Access Database - ASP
(03:43)
Creating a Connection with a Connection String - ASP
(01:55)
Creating a Remote DSN Connection - ASP
(02:14)
Connecting to a CFMX Data Source
(02:31)
Creating a Database Connection - ASP.NET
(03:34)
Creating a SQL Server Connection - ASP.NET
(01:08)
MySQL and PHP
Creating a MySQL Database
(04:51)
Converting Access to MySQL
(03:03)
Testing PHP in Dreamweaver MX
(01:07)
Connecting to MySQL Database
(02:44)
Additional Resources
(01:02)
Inserting Dynamic Data
Inserting Dynamic Data
(02:09)
Live Data View
(01:37)
Dynamic Images
(03:38)
Formatting Dynamic Data - ASP
(01:07)
Formatting Dynamic Data - CFM
(00:57)
Repeat Regions - All
(02:48)
Adding Navigation Tools
(04:54)
Dynamic Table - ASP
(02:09)
Dynamic Table - CFM
(02:04)
Binding Form Elements - ASP
(01:50)
Binding Form Elements - CFM
(01:48)
Live Data View Settings - All
(01:29)
Record Sets
Advanced Recordset Dialog - ASP
(02:52)
Advanced Recordset Dialog - CFM
(02:52)
Writing SQL Statements - All
(01:26)
Joining Multiple Tables - All
(03:47)
Sorting and Filtering Data - All
(01:45)
Editing and Duplicating Recordsets - All
(01:44)
Views - All
(00:48)
Stored Procedures & Command Object - ASP
(02:13)
Stored Procedures - CFM
(00:57)
Stored Procedures - ASP.NET
(00:47)
Master Detail Page Set
Master Detail Page Set Live Object - ASP
(03:59)
How Master Detail Page Set Works - ASP
(02:46)
Master Detail Page Set Live Object - CFM
(03:54)
How Master Detail Page Set works - CFM
(02:04)
Create Master Page Step by Step - ASP
(02:07)
Create Detail Page Step by Step - ASP
(02:02)
Create Master Page Step by Step - CFM
(02:33)
Create Detail Page Step by Step - CFM
(02:28)
Create Master Page - ASP.NET
(02:12)
Create Detail Page - ASP.NET
(02:51)
Record Insertion Form
Record Insertion Form - Live Object - ASP
(03:41)
Creating a Record Insertion Form Step by Step - ASP
(02:24)
Record Insertion Form - Live Object - CFM
(03:56)
Creating a Record Insertion Form Step by Step - CFM
(02:11)
Record Insertion Form - Live Object - ASP.NET
(03:45)
Creating a Record Insertion Form Step by Step - ASP.NET
(01:59)
Inserting New Record with Command Object - ASP
(03:48)
Updating and Deleting Records
Update Record Live Object - ASP
(03:27)
Update Record Live Object - CFM
(03:00)
Update Record Live Object - ASP.NET
(02:51)
Create Update Record Form Step by Step - ASP
(02:36)
Create Update Record Form Step by Step - CFM
(02:41)
Create Update Record Form Step by Step - ASP.NET
(02:41)
Deleting Records - ASP
(03:45)
Deleting Records - CFM
(02:57)
Deleting Records - ASP.NET
(03:07)
Delete Records with a DataGrid - ASP.NET
(01:19)
Search and Result Pages
Creating a Search Page - ASP
(01:29)
Creating a Results Page - ASP
(01:56)
Create a Dynamic List Box - ASP
(02:52)
Category Results Page - ASP
(03:39)
Dealing with Empty Recordsets - ASP
(01:48)
Creating a Search Page - CFM
(01:32)
Creating a Results Page - CFM
(02:04)
Create a Dynamic List Box - CFM
(02:54)
Category Results Page - CFM
(03:27)
Dealing with Empty Recordsets - CFM
(01:33)
Creating a Search Page - ASP.NET
(01:28)
Creating a Results Page - ASP.NET
(01:54)
Category Results Page - ASP.NET
(04:31)
Dealing with Empty Recordsets - ASP.NET
(01:54)
Displaying Records Based upon Likeness - ASP
(02:32)
Multiple Search Parameters - ASP
(01:00)
Displaying Search and Results on the Same Page - ASP
(00:54)
Displaying Records Based upon Likeness - CFM
(02:23)
Multiple Search Parameters - CFM
(01:03)
Displaying Search and Results on the Same Page - CFM
(00:48)
Displaying Records Based upon Likeness - ASP.NET
(02:19)
Multiple Search Parameters - ASP.NET
(00:50)
Displaying Search and Results on the Same Page - ASP.NET
(00:46)
Authentication
Login Users - ASP
(02:41)
Restricting User Access - ASP
(02:24)
Log out User - ASP
(01:10)
Session Variables - ASP
(01:54)
Checking for New Users - ASP
(01:32)
Login Users - CFM (1)
(01:58)
Login Users - CFM (2)
(02:11)
Restricting User Access - CFM
(02:19)
Log out User - CFM
(01:03)
Session Variables - CFM
(01:54)
Checking for Existing Users - CFM
(01:33)
Shopping Cart
Inserting the WA eCart Object
(03:20)
eCart Object Interface - General and Column Tabs
(03:56)
eCart Object Interface - Calculations Tab
(02:34)
Inserting an Add To Cart Button (1)
(02:46)
Inserting an Add To Cart Button (2)
(03:51)
Quick Checkout Buttons
(03:00)
Display Manager Overview
(05:25)
Merchandising Wizard - Product Discounts
(04:29)
Merchandising Wizard - Flat Rate Discounts
(01:51)
Merchandising Wizard - Sales Tax
(03:52)
Merchandising Wizard - Shipping
(03:49)
Using WA eCart with Dreamweaver MX Templates
(04:49)
ColdFusion
Creating a Dynamic Table
(06:50)
Total Records & Today’s Date
(01:54)
Dynamic Form Elements
(03:02)
Creating a Data Drill Down (1)
(02:48)
Creating a Data Drill Down (2)
(03:56)
Reusing Code
(02:45)
Local Variables
(02:28)
Server Debug
(02:19)
Components
(04:26)
Web Services
(04:41)
ColdFusion MX and XML
(03:45)
WA Dynamic Flash Charts
Overview
(01:32)
Creating a Chart with a Static Data Source (1)
(02:27)
Creating a Chart with a Static Data Source (2)
(05:29)
Creating a Chart with Dynamic Data Source (1)
(04:06)
Creating a Chart with Dynamic Data Source (2)
(01:48)
Upgrading a Flash Chart
(01:37)
WA Query Builder
Overview
(02:18)
Create the Master Detail Page
(02:30)
Query Builder Live Object
(04:42)
Making List Box Dynamic
(01:06)
Date Validation
(02:01)
WA Universal Email
Introduction
(00:35)
WA Universal Email - Basic (1)
(04:02)
WA Universal Email - Basic (2)
(03:14)
Creating a Mailing List
(02:48)
Retrieving User Details
(03:33)
Confirmation of Registration
(01:59)
HTML Mail
(02:36)
Universal Email Markup Tags
(04:00)
To view the Free Tutorials you must have Quicktime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.
See all VTC titles
