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.
IntroductionWhat is Dreamweaver MXSystem RequirementsLessons && Sites && Trial SoftwareWorkspace - WindowsWorkspace - MacintoshExtensibilityUsing CSSCreating Pages using XHTMLConfiguring Dreamweaver for the CourseUpdateDatabase PrimerWhat is a DatabaseDesigning DatabasesTypes of DatabasesRelational DatabasesCreating a DatabaseField Data TypesRelationshipsCreating RelationshipsDatabase QueriesCreating QueriesHow Queries are CreatedCreating IndexesMS SQL Server 2000Upsizing to MS SQL 2000What are Stored ProceduresWhat are ViewsSQLWhat is SQLSelect StatementsUsing Where && Order ByRetrieving DataUsing LIKEConnecting to DatabasesWeb && Application Servers
Types of Application Servers
Installing Personal Web Server
Configuring PWS
Configuring IIS
Interfacing with Databases
Database Drivers
Setting up a DSN
Connecting to an MS SQL Server
Connect to a CFMX Server
Creating a Connection in Cold Fusion MX to a MS SQL Server
Connecting a Macintosh to a Windows 2000 Server
Connecting from Mac OS9 to a Shared Windows Folder
Connecting from Mac OSX to a Shared Windows Folder (1)
Connecting from Mac OSX to a Shared Windows Folder (2)
Creating a SiteDefining a Site for ASP
Defining a Site for CFM
Defining a Site for ASP.NET
Deploying Supporting File - ASP.NET
Connecting to an Access Database - ASP
Creating a Connection with a Connection String - ASP
Creating a Remote DSN Connection - ASP
Connecting to a CFMX Data Source
Creating a Database Connection - ASP.NET
Creating a SQL Server Connection - ASP.NET
MySQL and PHPCreating a MySQL Database
Converting Access to MySQL
Testing PHP in Dreamweaver MX
Connecting to MySQL Database
Additional Resources
Inserting Dynamic DataInserting Dynamic Data
Live Data View
Dynamic Images
Formatting Dynamic Data - ASP
Formatting Dynamic Data - CFM
Repeat Regions - All
Adding Navigation Tools
Dynamic Table - ASP
Dynamic Table - CFM
Binding Form Elements - ASP
Binding Form Elements - CFM
Live Data View Settings - All
Record SetsAdvanced Recordset Dialog - ASP
Advanced Recordset Dialog - CFM
Writing SQL Statements - All
Joining Multiple Tables - All
Sorting and Filtering Data - All
Editing and Duplicating Recordsets - All
Views - All
Stored Procedures && Command Object - ASP
Stored Procedures - CFM
Stored Procedures - ASP.NET
Master Detail Page SetMaster Detail Page Set Live Object - ASP
How Master Detail Page Set Works - ASP
Master Detail Page Set Live Object - CFM
How Master Detail Page Set works - CFM
Create Master Page Step by Step - ASP
Create Detail Page Step by Step - ASP
Create Master Page Step by Step - CFM
Create Detail Page Step by Step - CFM
Create Master Page - ASP.NET
Create Detail Page - ASP.NET
Record Insertion FormRecord Insertion Form - Live Object - ASP
Creating a Record Insertion Form Step by Step - ASP
Record Insertion Form - Live Object - CFM
Creating a Record Insertion Form Step by Step - CFM
Record Insertion Form - Live Object - ASP.NET
Creating a Record Insertion Form Step by Step - ASP.NET
Inserting New Record with Command Object - ASP
Updating and Deleting RecordsUpdate Record Live Object - ASP
Update Record Live Object - CFM
Update Record Live Object - ASP.NET
Create Update Record Form Step by Step - ASP
Create Update Record Form Step by Step - CFM
Create Update Record Form Step by Step - ASP.NET
Deleting Records - ASP
Deleting Records - CFM
Deleting Records - ASP.NET
Delete Records with a DataGrid - ASP.NET
Search and Result PagesCreating a Search Page - ASP
Creating a Results Page - ASP
Create a Dynamic List Box - ASP
Category Results Page - ASP
Dealing with Empty Recordsets - ASP
Creating a Search Page - CFM
Creating a Results Page - CFM
Create a Dynamic List Box - CFM
Category Results Page - CFM
Dealing with Empty Recordsets - CFM
Creating a Search Page - ASP.NET
Creating a Results Page - ASP.NET
Category Results Page - ASP.NET
Dealing with Empty Recordsets - ASP.NET
Displaying Records Based upon Likeness - ASP
Multiple Search Parameters - ASP
Displaying Search and Results on the Same Page - ASP
Displaying Records Based upon Likeness - CFM
Multiple Search Parameters - CFM
Displaying Search and Results on the Same Page - CFM
Displaying Records Based upon Likeness - ASP.NET
Multiple Search Parameters - ASP.NET
Displaying Search and Results on the Same Page - ASP.NET
AuthenticationLogin Users - ASP
Restricting User Access - ASP
Log out User - ASP
Session Variables - ASP
Checking for New Users - ASP
Login Users - CFM (1)
Login Users - CFM (2)
Restricting User Access - CFM
Log out User - CFM
Session Variables - CFM
Checking for Existing Users - CFM
Shopping CartInserting the WA eCart Object
eCart Object Interface - General and Column Tabs
eCart Object Interface - Calculations Tab
Inserting an Add To Cart Button (1)
Inserting an Add To Cart Button (2)
Quick Checkout Buttons
Display Manager Overview
Merchandising Wizard - Product Discounts
Merchandising Wizard - Flat Rate Discounts
Merchandising Wizard - Sales Tax
Merchandising Wizard - Shipping
Using WA eCart with Dreamweaver MX Templates
ColdFusionCreating a Dynamic Table
Total Records && Today s Date
Dynamic Form Elements
Creating a Data Drill Down (1)
Creating a Data Drill Down (2)
Reusing Code
Local Variables
Server Debug
Components
Web Services
ColdFusion MX and XML
WA Dynamic Flash ChartsOverview
Creating a Chart with a Static Data Source (1)
Creating a Chart with a Static Data Source (2)
Creating a Chart with Dynamic Data Source (1)
Creating a Chart with Dynamic Data Source (2)
Upgrading a Flash Chart
WA Query BuilderOverview
Create the Master Detail Page
Query Builder Live Object
Making List Box Dynamic
Date Validation
WA Universal EmailIntroduction
WA Universal Email - Basic (1)
WA Universal Email - Basic (2)
Creating a Mailing List
Retrieving User Details
Confirmation of Registration
HTML Mail
Universal Email Markup Tags
Click here to find out more about the Macromedia Dreamweaver MX - Web Applications Training CD