ASP Scripting

Welcome
Welcome
Prerequisites for this Course
About this Course
Where to Find Documentation

What is ASP?
Active Server Pages (ASP)
Extending ASP
Client Based Scripting - VBScript
Client Based Scripting - JavaScript
Server Based Scripting
Why is Server Based Scripting Necessary?
Alternatives to ASP
Pros and Cons of Using ASP

Tools for ASP Development
What is IIS? (Internet Information Server)
Installing IIS
Getting IIS Up and Running pt. 1
Getting IIS Up and Running pt. 2
Using PWS (Personal Web Server)
Creating a Simple ASP Scripting Example
Using Visual Interdev
Using the Microsoft Script Debugger

Using VBScript
VBScript in Web Pages
Procedures and Functions
The Basics - Datatypes
The Basics - Variables
The Basics - Constants
The Basics - Operators
The Basics - Other Stuff
Programming Control Structures
Objects/Properties and Methods
A Quick Look at JScript

The Basics of ASP Scripting
From ASP to HTML
HTML Tags in ASP
Referring to Existing HTML Elements
Header Stuff
The GLOBAL.ASA File
Application and Session Objects
A Hit Counter Page
The Default Start Page
Text Files and Concurrency
Client Persistence and Cookies
Send and Retrieve
Including Objects in ASP
Exclude Business Logic from ASP
Including Scripts for Reuse pt. 1
Including Scripts for Reuse pt. 2
What's New in ASP3?

Introducing Built In ASP Objects
What are the Built In ASP Objects?
The Response Object
The Request Object
The Application Object
The Session Object
The Server Object
The Error Object
The File System
The Dictionary Object

Simple Built In ASP Objects
The Application Object pt. 1
The Application Object pt. 2
The Application Object pt. 3
The Application Object pt. 4
The Error Object
The Dictionary Object
The Server Object pt. 1
The Server Object pt. 2
The Server Object pt. 3

The Response Object
The Response Object
Writing Text to the Client
Redirecting to a New URL
Controlling Response with the Buffer
Ending and Expiring Pages
Client and Page Status
Content Type and Character Set
Obscure Properties and Methods

The Request Object
The Request Object
Server Variables
QueryString URL Parameters
QueryString Multiple URL Parameters
QueryString FORM METHOD=GET
Request.Form
Obscure Properties and Methods

The Session Object
What is a Session?
The Session Object
Session Start and End Events
The Contents Collection pt. 1
The Contents Collection pt. 2
Connecting and Disconnecting
Obscure Session Properties

Data Persistence on the Client
What is Persistence?
What is a Cookie?
Cookies in ASP
Multiple Valued Cookies pt. 1
Multiple Valued Cookies pt. 2
Session Cookies
Are Cookies Enabled on the Client?

Persistence and the File System
ASP Objects and the File System
The FileSystem Object
Using the FileSystem Object pt. 1
Using the FileSystem Object pt. 2
The TextStream Object
Using the TextStream Object
The Drive Object
The File Object
The Folder Object

Database Persistence and ADO
Database Drivers
Configuring ODBC and OLEDB
Reading an Oracle Database
Reading an Access Database
What is ADO?
ADO Object Hierarchy
ADO Objects Function and Purpose
ADO Object Attributes pt. 1
ADO Object Attributes pt. 2

ADO/ASP/ SQL
The Most Significant ADO Objects
Recordset Transparent SQL
What is SQL? The SELECT Statement
INSERT/UPDATE/DELETE
SELECT Statement Syntax
SELECT Statement Syntax WHERE Clause
SELECT Statement Syntax: GROUP BY
SELECT Statement Syntax: ORDER BY
INSERT Statement Syntax
UPDATE Statement Syntax
DELETE Statement Syntax
What is a Transaction?

Retrieving Data From a Database
What is a Recordset?
Recordset Fields and Values
Opening a Recordset
Closing and Emptying Objects
Advanced Recordset Options pt. 1
Advanced Recordset Options pt. 2
Paging Partial Recordsets
Disconnected Recordsets pt. 1
Disconnected Recordsets pt. 2

Changing Data in a Database
Adding Rows
The SQL INSERT Statement pt. 1
The SQL INSERT Statement pt. 2
Recordset.Addnew pt. 1
Recordset.Addnew pt. 2
Changing Rows
The SQL UPDATE Statement pt. 1
The SQL UPDATE Statement pt. 2
Recordset.Update
Batch Updates pt. 1
Batch Updates pt. 2
Batch Updates pt. 3
Deleting Rows
The SQL DELETE Statement
Recordset.Delete

Using Stored Procedures
Stored Procedures and Functions
Executing a Stored Procedure
Using Input Parameters
Input and Output Parameters
Input / Output Parameters
Using Functions

Components
Instantiating Components
IIS Resource Kit Components
E-Mail
Windows Scripting Components
Charting
Where Can Components be Found?

XML in ASP
What is XML?
What is XSL?
The XML Dynamic Object Model in ASP
Rendering XML Using XSL in ASP
Generating XML Manually from a Database

Wrapping it Up
Debugging ASP
Tuning ASP pt. 1
Tuning ASP pt. 2
Security ASP and IIS
The Future: ASP.NET
What You Have Learned

Credits
About the Author