ASP Scripting Tutorial

Welcome Welcome Demo
Prerequisites for this Course Demo
About this Course Demo
Where to Find Documentation Demo
What is ASP? Active Server Pages (ASP) Demo
Extending ASP Demo
Client Based Scripting - VBScript Demo
Client Based Scripting - JavaScript Demo
Server Based Scripting Demo
Why is Server Based Scripting Necessary? Demo
Alternatives to ASP Demo
Pros and Cons of Using ASP Demo
Tools for ASP Development What is IIS? (Internet Information Server) Demo
Installing IIS Demo
Getting IIS Up and Running Demo
Getting IIS Up and Running Demo
Using PWS (Personal Web Server) Demo
Creating a Simple ASP Scripting Example Demo
Using Visual Interdev Demo
Using the Microsoft Script Debugger Demo 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