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

Content of Training ASP / Advanced

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 $