| |
| |
| |
At a Glance | |
| |
| |
| |
Getting Started with Active Server Pages | |
| |
| |
What Are Active Server Pages? | |
| |
| |
Understanding the Client-Server Model | |
| |
| |
How ASP Differs from Client-Side Scripting Technologies | |
| |
| |
Running ASP Pages | |
| |
| |
Setting Up Personal Web Server | |
| |
| |
Setting Up Internet Information Server | |
| |
| |
Using ASP Without IIS or PWS | |
| |
| |
Creating ASP Pages | |
| |
| |
Using Visual InterDev | |
| |
| |
Using FrontPage | |
| |
| |
Creating Your First ASP Pages | |
| |
| |
Summary | |
| |
| |
Q and A | |
| |
| |
Workshop | |
| |
| |
Quiz | |
| |
| |
Exercise | |
| |
| |
| |
Dissecting Your First ASP Script | |
| |
| |
Understanding ASP Scripts | |
| |
| |
What Does Response. Write Do? | |
| |
| |
The [%= Shortcut | |
| |
| |
What's with the [%@ LANGUAGE=VBSCRIPT%]? | |
| |
| |
Writing ASP Code Without Using [%. . . %] | |
| |
| |
Comments | |
| |
| |
Line Continuation Character | |
| |
| |
Things to Come | |
| |
| |
What Your ASP Script Returned to the Browser | |
| |
| |
The ASP Process | |
| |
| |
Summary | |
| |
| |
Q and A | |
| |
| |
Workshop | |
| |
| |
Quiz | |
| |
| |
Exercises | |
| |
| |
| |
Working with Variables | |
| |
| |
What Is a Variable? | |
| |
| |
Data Types | |
| |
| |
Integer | |
| |
| |
Floating-point Numbers | |
| |
| |
String | |
| |
| |
Date | |
| |
| |
Boolean | |
| |
| |
Currency | |
| |
| |
Object | |
| |
| |
What Are Variant Variables? | |
| |
| |
What Does It Mean to Declare a Variable? | |
| |
| |
Why Use Explicit Declarations in VBScript? | |
| |
| |
How Do You Name a Variable? | |
| |
| |
Constants | |
| |
| |
Arrays | |
| |
| |
How Do You Determine Your Variable's Type? | |
| |
| |
VBScript Operators | |
| |
| |
Assignment Operator | |
| |
| |
Mathematical Operators | |
| |
| |
Subtraction | |
| |
| |
Multiplication | |
| |
| |
Division | |
| |
| |
Integer Division | |
| |
| |
Modulus | |
| |
| |
Exponentiation | |
| |
| |
Negation | |
| |
| |
Concatenation | |
| |
| |
Comparison Operators | |
| |
| |
Logical Operators | |
| |
| |
Summary | |
| |
| |
Q and A | |
| |
| |
Workshop | |
| |
| |
Quiz | |
| |
| |
Exercises | |
| |
| |
| |
Understanding VBScript Control Structures | |
| |
| |
What Is a Control Structure? | |
| |
| |
Types of Controls | |
| |
| |
Conditional Logic | |
| |
| |
Looping Logic | |
| |
| |
Branching Logic | |
| |
| |
Control Structure Examples | |
| |
| |
Conditional Logic Controls | |
| |
| |
Looping Logic Controls | |
| |
| |
Branching Logic Controls | |
| |
| |
Summary | |
| |
| |
Q and A | |
| |
| |
Workshop | |
| |
| |
Quiz | |
| |
| |
Exercises | |
| |
| |
| |
Using VBScript's Built-in Functions | |
| |
| |
Typecasting Variables | |
| |
| |
What Is Typecasting and Why Should I Typecast? | |
| |
| |
How to Typecast Your Variables | |
| |
| |
Formatting Functions | |
| |
| |
Math Functions | |
| |
| |
Date Functions | |
| |
| |
Working with Date Values | |
| |
| |
Breaking Down Date Values | |
| |
| |
String Functions | |
| |
| |
Other Functions | |
| |
| |
Summary | |
| |
| |
Q and A | |
| |
| |
Workshop | |
| |
| |
Quiz | |
| |
| |
Exercises | |
| |
| |
| |
Working with Objects | |
| |
| |
What Are Objects? | |
| |
| |
The Building Blocks of Objects | |
| |
| |
Properties | |
| |
| |
Methods | |
| |
| |
Instances of Objects | |
| |
| |
Built-in ASP Objects | |
| |
| |
Response Object | |
| |
| |
Request Object | |
| |
| |
Application Object | |
| |
| |
Session Object | |
| |
| |
Server Object | |
| |
| |
ObjectContext Object | |
| |
| |
ASPError Object | |
| |
| |
Collections | |
| |
| |
Working with Objects | |
| |
| |
Events | |
| |
| |
Summary | |
| |
| |
Q and A | |
| |
| |
Workshop | |
| |
| |
Quiz | |
| |
| |
Exercises | |
| |
| |
| |
Using the Response Object | |
| |
| |
What Is the Response Object? | |
| |
| |
Dissecting the Response Object | |
| |
| |
Sending HTML to the Brower | |
| |
| |
Buffering ASP Pages | |
| |
| |
Sending the User to Another Page | |
| |
| |
Cookies | |
| |
| |
Caching Your ASP Pages | |
| |
| |
Summary | |
| |
| |
Q and A | |
| |
| |
Workshop | |
| |
| |
Quiz | |
| |
| |
Exercises | |
| |
| |
| |
In Review | |
| |
| |
Bonus Project 1 | |
| |
| |
Creating a Calendar | |
| |
| |
Building the Calendar | |
| |
| |
The Complete Code | |
| |
| |
| |
At a Glance | |
| |
| |
| |
Communicating with the User | |
| |
| |
Receiving Information from the User | |
| |
| |
What Are Forms? | |
| |
| |
Creating Forms | |
| |
| |
Designing Forms | |
| |
| |
Submitting Forms | |
| |
| |
Reading Form Values from an ASP Page | |
| |
| |
Using Advanced Form Techniques | |
| |
| |
Revisiting the ACTION Property | |
| |
| |
Client-Side Form Validation | |
| |
| |
Using the Different Form Fields | |
| |
| |
Text Boxes | |
| |
| |
List Boxes | |
| |
| |
Check Boxes | |
| |
| |
Radio Buttons | |
| |
| |
Choosing your Checkboxes and Radio Buttons | |
| |
| |
Summary | |
| |
| |
Q and A | |
| |
| |
Workshop | |
| |
| |
Quiz | |
| |
| |
Exercises | |
| |
| |
| |
Collecting the Form Information | |
| |
| |
Retrieving the Results of a Form | |
| |
| |
Using the Request Object | |
| |
| |
Using the Querystring to Send Information | |
| |
| |
Summary | |
| |
| |
Q and A | |
| |
| |
Workshop | |
| |
| |
Quiz | |
| |
| |
Exercises | |
| |
| |
| |
Working with the Request Object | |
| |
| |
Accessing the HTTP Headers | |
| |
| |
Useful HTTP Headers | |
| |
| |
Reading the HTTP Headers with Request.ServerVariables | |
| |
| |
Accessing the Environment Variables | |
| |
| |
Useful Environment Variables | |
| |
| |
Reading the Environment Variables Using Request.ServerVariables | |
| |
| |
Using Cookies | |
| |
| |
What Are Cookies? | |
| |
| |
How to Read Cookies Using the Request Object | |
| |
| |
How to Write Cookies Using the Response Object | |
| |
| |
Advantages and Disadvantages of Using Cookies | |
| |
| |
Summary | |
| |
| |
Q and A | |
| |
| |
Workshop | |
| |
| |
Quiz | |
| |
| |
Exercises | |
| |
| |
| |
Maintaining Persistent Information on the Web | |
| |
| |
It's a Fact: The Web Is Stateless | |
| |
| |
Ways to Maintain State | |
| |
| |
The Session Object | |
| |
| |
Using Session Variables | |
| |
| |
Pitfalls of Session Variables | |
| |
| |
Session Variables Without Cookies | |
| |
| |
The Application Object | |
| |
| |
Using Application Variables | |
| |
| |
Pitfalls of Application Variables | |
| |
| |
Initializing Application and Session Variables | |
| |
| |
Creating a Global.asa File | |
| |
| |
Summary | |
| |
| |
Q and A | |
| |
| |
Workshop | |
| |
| |
Quiz | |
| |
| |
Exercises | |
| |
| |
| |
Working with Common ASP Components | |
| |
| |
Using Components | |
| |
| |
Components Make Life Easy | |
| |
| |
Using a Component in ASP | |
| |
| |
Developing with Microsoft's ASP Components | |
| |
| |
Ad Rotator | |
| |
| |
Content Linker | |
| |
| |
Browser Capabilities Component | |
| |
| |
Summary | |
| |
| |
Q and A | |
| |
| |
Workshop | |
| |
| |
Quiz | |
| |
| |
Exercises | |
| |
| |
| |
Reading and Writing Files on the Web Server | |
| |
| |
Server-Side Includes | |
| |
| |
Using Server-Side Includes to Simplify Maintenance | |
| |
| |
Redirecting Users | |
| |
| |
Executing Another ASP Page | |
| |
| |
Transferring Control to Another ASP Page | |
| |
| |
Accessing Files and Folders | |
| |
| |
Determining Whether Files or Folders Exist | |
| |
| |
Determining the Properties of Files and Folders on the Web Server | |
| |
| |
Opening Files | |
| |
| |
Reading Files | |
| |
| |
Writing Files to the Server | |
| |
| |
Appending to Files | |
| |
| |
Summary | |
| |
| |
Q and A | |
| |
| |
Workshop | |
| |
| |
Quiz | |
| |
| |
Exercises | |
| |
| |
| |
Debugging Your ASP Scripts and Handling Errors | |
| |
| |
Debugging Your ASP Scripts | |
| |
| |
Debugging Fatal Bugs | |
| |
| |
Debugging Nonfatal Bugs | |
| |
| |
Handling ASP Errors Gracefully | |
| |
| |
Using the Err Object | |
| |
| |
Using the ASPError Object | |
| |
| |
Handling Non-ASP Errors Gracefully | |
| |
| |
Summary | |
| |
| |
Q and A | |
| |
| |
Workshop | |
| |
| |
Quiz | |
| |
| |
Exercises | |
| |
| |
| |
In Review | |
| |
| |
Bonus Project 2 | |
| |
| |
Enhancing the Calendar | |
| |
| |
Allowing the User to Selectively View a Given Month | |
| |
| |
The Complete Code | |
| |
| |
Where You're Going | |
| |
| |
| |
At a Glance | |
| |
| |
| |
Using Databases | |
| |
| |
What Are Relational Databases? | |
| |
| |
Common Relational Databases | |
| |
| |
Why Use Databases? | |
| |
| |
Working with Databases Using ASP | |
| |
| |
Summary | |
| |
| |
Q and A | |
| |
| |
Workshop | |
| |
| |
Quiz | |
| |
| |
Exercise | |
| |
| |
| |
Reading from a Database Using ASP | |
| |
| |
Databases and ASP | |
| |
| |
Communicating with a Database Using Active X Data Objects (ADO) | |
| |
| |
Connecting to a Database | |
| |
| |
The Connection Object | |
| |
| |
Using a System DSN | |
| |
| |
Using a DSN-less Connection | |
| |
| |
Opening the Connection | |
| |
| |
Closing the Connection | |
| |
| |
Properties of the Connection | |
| |
| |
Reading Data from a Database | |
| |
| |
The Recordset Object | |
| |
| |
Using adovbs.inc | |
| |
| |
Reading and Displaying the Contents of a Database Table | |
| |
| |
Summary | |
| |
| |
Q and A | |
| |
| |
Workshop | |
| |
| |
Quiz | |
| |
| |
Exercises | |
| |
| |
| |
Inserting, Updating, and Deleting Database Records | |
| |
| |
Inserting Records | |
| |
| |
Lock Types | |
| |
| |
AddNew and Update | |
| |
| |
Updating Records | |
| |
| |
Deleting Records | |
| |
| |
Summary | |
| |
| |
Q and A | |
| |
| |
Workshop | |
| |
| |
Quiz | |
| |
| |
Exercises | |
| |
| |
| |
Examining the Recordset Object | |
| |
| |
Enhancing Information Retrieval | |
| |
| |
Using the Fields Collection | |
| |
| |
Understanding the CursorType and CursorLocation Properties | |
| |
| |
Sorting Recordsets | |
| |
| |
Filtering Recordsets | |
| |
| |
Filtering Recordsets Based on User Input | |
| |
| |
Summary | |
| |
| |
Q and A | |
| |
| |
Workshop | |
| |
| |
Quiz | |
| |
| |
Exercises | |
| |
| |
| |
Using SQL Statements to Query Data | |
| |
| |
What Is SQL? | |
| |
| |
Executing SQL Statements Using ASP and ADO | |
| |
| |
The SELECT SQL Statement | |
| |
| |
Using the WHERE Clause | |
| |
| |
Working with the ORDER BY Clause | |
| |
| |
Iterating Through Recordsets Generated by SQL Statements | |
| |
| |
Allowing Users to Query Data | |
| |
| |
Summary | |
| |
| |
Q and A | |
| |
| |
Workshop | |
| |
| |
Quiz | |
| |
| |
Exercises | |
| |
| |
| |
Using Advanced Database Techniques | |
| |
| |
Advanced Features of the Recordset Object | |
| |
| |
Choosing the Right Cursor | |
| |
| |
Understanding LockType | |
| |
| |
Creating Recordsets with Connection.Execute | |
| |
| |
Using Stored Procedures | |
| |
| |
Benefits of Using Stored Procedures | |
| |
| |
Creating Stored Procedures in Microsoft SQL Server | |
| |
| |
Creating Stored Procedures in Access | |
| |
| |
Calling Stored Procedures from ASP | |
| |
| |
The Command Object | |
| |
| |
Summary | |
| |
| |
Q and A | |
| |
| |
Workshop | |
| |
| |
Quiz | |
| |
| |
Exercises | |
| |
| |
| |
Practicing Intelligent Application Design | |
| |
| |
Why Design Matters | |
| |
| |
Making Changes to Your Database | |
| |
| |
Making Changes to Your ASP Pages | |
| |
| |
Good Database Design Techniques | |
| |
| |
Normalizing Your Databases | |
| |
| |
Using Lookup Tables | |
| |
| |
Naming Conventions | |
| |
| |
Using Stored Procedures | |
| |
| |
Good ASP Design Techniques | |
| |
| |
Practiced ASP Programming Techniques | |
| |
| |
Summary | |
| |
| |
Q and A | |
| |
| |
Workshop | |
| |
| |
Quiz | |
| |
| |
Exercise | |
| |
| |
| |
In Review | |
| |
| |
Bonus Project 3 | |
| |
| |
Adding Events to the Calendar | |
| |
| |
Designing the Event Database | |
| |
| |
Displaying the Events | |
| |
| |
The Calendar Application: Where to Go Next | |
| |
| |
| |
Answers to the Quiz Questions | |
| |
| |
| |
VBScript Reference | |
| |
| |
Statements and Keywords | |
| |
| |
Operators | |
| |
| |
VBScript Functions | |
| |
| |
Type Checking Functions | |
| |
| |
Typecasting Functions | |
| |
| |
Formatting Functions | |
| |
| |
Math Functions | |
| |
| |
Date Functions | |
| |
| |
String Functions | |
| |
| |
Other functions | |
| |
| |
Control Structures | |
| |
| |
Conditional Structures | |
| |
| |
Looping Structures | |
| |
| |
Branching Structures | |
| |
| |
File System Object | |
| |
| |
File Object | |
| |
| |
Folder Object | |
| |
| |
Drive Object | |
| |
| |
TextStream Object | |
| |
| |
| |
Built-in ASP Objects | |
| |
| |
Application Object | |
| |
| |
ASPError Object | |
| |
| |
ObjectContext Object | |
| |
| |
Request Object | |
| |
| |
Response Object | |
| |
| |
Session Object | |
| |
| |
Server Object | |
| |
| |
| |
Helpful ASP Information on the Net | |
| |
| |
Index | |