Mastering Dreamweaver MX Databases
Mastering Dreamweaver MX Databases
ISBN: 078214148X
EAN: 2147483647
EAN: 2147483647
Year: 2002
Pages: 214
Pages: 214
- 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
Mastering Dreamweaver MX Databases
ISBN: 078214148X
EAN: 2147483647
EAN: 2147483647
Year: 2002
Pages: 214
Pages: 214