---

Mastering Dreamweaver MX Databases

ISBN: 078214148X
EAN: 2147483647

Year: 2002
Pages: 214

Authors: Susan Sales Harkins, Bryan Chamberlain, Darren McGee

BUY ON AMAZON

• Table of Contents
• BackCover
• Mastering Dreamweaver MX Databases
• Introduction
• Who Can Develop a Data-Driven Website?
• What You Need
• How This Book Is Organized
• What s on the CD
• Tell Us What You Think
• Part I: Data-Driven Web Pages
• Chapter 1: An Introduction to the Data-Driven World
• The Benefits of Offering Dynamic Data
• New Technologies and Terms
• Scripting for Servers
• Match a Database to Your Needs
• Summary
• Chapter 2: An Introduction to Dreamweaver MX
• A Bit of History
• Installing and Running Dreamweaver MX for the First Time
• Installing a Local Web Server
• Configuring Dreamweaver MX to Suit Your Needs
• Setting Up Your PCServer Environment for Dreamweaver MX
• Site Management and Transferring Files
• Summary
• Chapter 3: Coding Practices for Dreamweaver Development
• Comment Your Code
• Naming Conventions
• Web Code Structure
• Error Checking and Data Validation
• Using the Tag Library Editor
• Summary
• Chapter 4: An Introduction to HTML Forms
• An Introduction to HTML
• What Is an HTML Form?
• HTTP Headers
• Input Elements
• Adding Form Objects and Fields in Dreamweaver MX
• Post versus Get
• Summary
• Part II: The Databases
• Chapter 5: Designing the Database
• Redundant Data-the Purpose Behind Relational Database Theory
• Normalization-the Solution Behind the Theory
• Demystifying Keys
• The Design Process
• Taking on Referential Integrity
• Some Systems Support Cascading Options
• Summary
• Chapter 6: Oracle and the Web
• The Oracle Product Family
• Dreamweaver MX, Oracle, and SQL
• Oracle Datatypes
• Key Oracle SQL Functions
• Constructing SQL Statements for Oracle
• Oracle Connection Options
• Summary
• Chapter 7: MySQL and the Web
• Dreamweaver MX, MySQL, and PHP
• MySQL Datatypes
• MySQL Functions
• MySQL Syntax
• Summary
• Chapter 8: SQL Server and the Web
• The SQL Server Package
• Web Support
• SQL Server Components
• SQL Server Datatypes
• Native Functions
• Using Transact-SQL in SQL Server
• Migrating from Access to SQL Server
• Connection Options
• Summary
• Chapter 9: Microsoft Access and the Web
• The Access Package
• Web Support
• Jet Datatypes
• Built-in Functions
• Jet SQL
• Upsizing an Access Database to SQL Server
• Connection Options
• Access as a Platform for Web Development
• Summary
• Part III: Paving the Way-The Languages
• Chapter 10: Connections and Scripting
• Dreamweaver MX and Database Connections
• Managing an Existing Data Connection
• Troubleshooting Data Connections
• Microsoft Error Messages
• Summary
• Chapter 11: ColdFusion and Dreamweaver MX
• ColdFusion-the Web Application Server (or Host)
• ColdFusion-the Language
• ColdFusion-the Development Environment
• Summary
• Chapter 12: JavaServer Pages
• JavaServer Pages: Selecting a Host
• JavaServer Pages: The Language
• JSP Elements
• Working in JSP
• Summary
• Chapter 13: Active Server Pages
• Active Server Pages--the Host and the Scripting Languages
• ASP Objects
• Summary
• Chapter 14: Dreamweaver and ASP.NET
• The .NET Framework
• ASP.NET-the Host
• ASP.NET-VB.NET or C
• ASP.NET Web Forms
• Using ASP.NET Server Controls
• Active and Passive Events
• Specifying Validation
• ASP.NET Objects
• ASP.NET XML Web Services
• Summary
• Chapter 15: ADO.NET
• What Is ADO.NET?
• Binding Data in Web Forms
• Summary
• Chapter 16: PHP and Dreamweaver MX
• PHP-the Language
• Dreamweaver and PHP
• Summary
• Chapter 17: Database and System Security for the Internet
• Types of Threats
• Protect Your Intellectual Property
• Protect Your Web Server
• Protect Your Database
• Using Dreamweaver MX to Apply Security to Your Pages
• Summary
• Part IV: Using and Manipulating the Data
• Chapter 18: Structured Query Language
• What Is SQL?
• Standardization
• Syntax and Structure
• Using Data Manipulation Language to Retrieve and Modify Data
• SQL Operators
• Delimiting and Concatenating
• SQL Aggregate Functions
• Summary
• Chapter 19: Getting the Data
• Previewing Your Pages
• Setting the Testing Server Options
• Creating Dynamic Pages
• Summary
• Chapter 20: Building Update Forms
• A Few Form Rules
• Inserting a Form in Dreamweaver MX
• Adding Web Controls to a Form
• Creating an Insert Page
• Updating a Record
• Deleting a Record
• Summary
• Chapter 21: Building MasterDetail Page Sets
• The Drill-Down Model
• Building MasterDetail Pages
• Using the Master Detail Page Set Server Behavior
• Creating a MasterDetail Page Set from Components
• Creating a MasterDetail Page Set Using PHP
• Summary
• Chapter 22: Searching with Dreamweaver MX
• Performing a Simple Search
• Performing a More Advanced Search
• Summary
• Chapter 23: Using Templates
• The Benefits of Using Templates
• Template Anatomy
• Creating a Template
• Creating a New Page from a Template
• Applying a Template to an Existing Document
• Building a Template
• Creating a Template-Based Page
• Viewing a Template-Based Page
• Adding Dynamic Text
• Summary
• Chapter 24: Dreamweaver MX Add-Ins
• Dreamweaver MX Extensions
• The Macromedia Exchange
• Some Extensions We Find Particularly Useful
• Summary
• Datatypes and Functions Compared
• Functions in Dreamweaver MX-Compatible Database Management Systems
• Datatypes in Dreamweaver MX-Compatible Database Management Systems
• Index
• Index_A
• Index_B
• Index_C
• Index_D
• Index_E
• Index_F
• Index_G
• Index_H
• Index_I
• Index_J
• Index_K
• Index_L
• Index_M
• Index_N
• Index_O
• Index_P
• Index_Q
• Index_R
• Index_S
• Index_T
• Index_U
• Index_W
• Index_X
• Index_Y
• Index_Z
• List of Figures
• List of Tables
• List of Code Examples
• List of Sidebars