Advanced ASP Training

Delivery Options

• Live eLearning (2 days): $790.00 (Register)

» Register Now

» Free Demo

» Watch Presentation

» Contact Education Consultant

• Customized Onsite Training (2 days): Request a Proposal

Class Date and Time	Price Volume Discounts Students Discounts 2 5% 3-4 10% 5 or more 15% GSA Price: $750.50	Register
Mar 25 - 26, 2010 10:00 AM - 5:00 PM ET	$790.00 or 2 vouchers	Register
Apr 15 - 16, 2010 10:00 AM - 5:00 PM ET	$790.00 or 2 vouchers	Register
May 13 - 14, 2010 10:00 AM - 5:00 PM ET	$790.00 or 2 vouchers	Register
Jun 3 - 4, 2010 10:00 AM - 5:00 PM ET	$790.00 or 2 vouchers	Register

Show More Classes

Class Description

Class Overview

Class 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

Class 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 $

Class Materials

All students receive a course manual or book and all the class examples.

Students in private onsite classes will also receive:

• Technical Reference Library

Class Prerequisites

Experience in the following areas is required:

• Basic ASP Skills

Technical Requirements

Our computer technical requirements and setup process is easy, with support just a click away.

• Course technical requirements and setup instructions.