Advanced Active Server Pages (2 days)

Advanced ASP Training Overview

In this advanced ASP training course, students will learn to use sophisticated programming strategies and advanced features to add polish, speed and efficiency to Active Server Pages Web applications. In this ASP training course, students will work more thoroughly with ASP components for Web-to-database integration and use the server's file system to add features and functionality to a website. In addition, students will learn to work with other built-in and third-party components.

Advanced ASP Training Course Goals

• Learn to implement advanced drill-downs
• Learn to debug ASP code
• Learn to work with stored procedures
• Learn to use batch updating
• Learn to work with 3rd-party vendor components
• Learn to work with the file system of the server

Advanced ASP Training Course Prerequisites

Experience in the following areas is required:

• Basic ASP Skills

Advanced ASP Training Course Outline

1. File Conventions
   1. Connection Pooling
   2. Dynamic Connection Strings
   3. Default METHOD and ACTION Values
2. Advanced Data Drill-Downs
   1. Passing Data via the Query String
   2. Using Drill-Downs to Reformat Data
   3. Creating Sortable Tables
3. Displaying Variables
   1. Creating an Include to Display Variable Values for Debugging
4. Displaying a Portion of a Recordset
   1. Displaying the Next n Records
   2. How the Process Works
5. Password Protection with Session Variables
   1. Adding Password Protection to Pages
6. Stored Procedures in ASP
   1. Creating a Stored Procedure in the Database
   2. Advantage of Stored Procedures
   3. Calling a Stored Procedure
   4. Using Stored Procedures to Insert and Update Data
7. Working with the File System in ASP
   1. The FileSystemObject
   2. Creating or Opening a Text File
   3. Methods of the TextStream Object
   4. Storing Text to a File
   5. The File Object
   6. The Folder Object
   7. Working with Files and Directories
8. Processing File Uploads
   1. Obtaining a Component for Processing File Uploads
   2. The AspUpload Component
   3. Building an HTML Form that Supports File Uploads
   4. Processing the File on the Server with AspUpload
   5. Processing Files and Entered Text
   6. SetMaxSize
   7. Manipulating Files via AspUpload
   8. Creating an New Directory
   9. Restricting Your Upload to Certain File Extensions
   10. Building a Resume Submission Interface
9. Batch Updating
   1. Opening a Recordset for Batch Updating
   2. Editing the Records Row by Row
   3. Updating the Batch
   4. Benefits of Batches
   5. Some Useful VBScript Functions
10. Using rs.Update Instead of INSERT
    1. rs.Update
11. Form Validation with Server-Side JScript
    1. Server-Side Form Validation with JScript
12. Transactions in ASP
    1. Transactions
    2. Handling Errors
    3. Catching Database Errors
13. Creating Message Boards
    1. The HTML Files
    2. The Database
    3. The Interface
14. Regular Expressions
    1. Creating and Executing Regular Expressions with exec()
    2. Special Characters for Pattern Matching
    3. Escape Sequences for Special Characters
    4. Specifying Ranges in Patterns
    5. Matching a Specified Number of Occurrences
    6. Character-Range Escape Sequences
    7. Matching at the Beginning or End of a String with ^ and $

Advanced ASP Training Course Materials

Each student will receive a comprehensive set of materials, including course notes and all the programming examples.

Advanced ASP Training Technical Requirements

1. Operating System Options
   • Windows Vista
   • Windows XP with Service Pack 2
2. Internet Information Services
   • Instructions
3. Microsoft Access 2000 or later

Class Files for Advanced ASP Training

1. Download the class files.
2. After downloading the files, click here for further instructions.