Flylib.com
Mastering Dreamweaver MX Databases
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
Mastering Dreamweaver MX Databases
ISBN: 078214148X
EAN: 2147483647
Year: 2002
Pages: 214
Authors:
Susan Sales Harkins
,
Bryan Chamberlain
,
Darren McGee
BUY ON AMAZON
SQL Tips & Techniques (Miscellaneous)
Working with Queries, Expressions, and Aggregate Functions
Working with Data BLOBs and Text
Working with Ms-sql Server Information Schema View
Monitoring and Enhancing MS-SQL Server Performance
Writing Advanced Queries and Subqueries
Adobe After Effects 7.0 Studio Techniques
Understanding and Optimizing Keylight
Fixing Typical Problems
Using 3D Tracking Data
5D: Pick Up the Camera
Shadows and Reflected Light
Microsoft Windows Server 2003(c) TCP/IP Protocols and Services (c) Technical Reference
Address Resolution Protocol (ARP)
Internet Protocol (IP) Addressing
Transmission Control Protocol (TCP) Connections
RADIUS and Internet Authentication Service
Internet Protocol Security (IPSec)
Special Edition Using Crystal Reports 10
Understanding Data and Data Sources
Filtering the Data in Your Report
Creating and Implementing Parameters Fields
Creating Advanced Record Selection Formulas
Using Brackets in Formulas
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
History of SQL*Plus
Why Master SQL*Plus?
Master/Detail Reports
Types of Output Files
What Is the Product User Profile?
Microsoft Office Visio 2007 Step by Step (Step By Step (Microsoft))
Creating Organization Charts
Importing Data to Create Organization Charts
Key Points
Glossary
About the Authors
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies