Advanced Active Server Pages

This course will teach students how to use sophisticated programming strategies and advanced features to add polish, speed and efficiency to Active Server Pages Web applications. During this course, students will work more thoroughly with ASP components for Web-to-database integration and use the server's file system to add web site features and functionality. Students will also work with other components, including those that ship with ASP as well as those you can purchase from 3rd party vendors.

After completing this two-day course, students will be able to:

• Implement Advanced Drill-Downs
• Debug Your ASP Code
• Work With Stored Procedures
• Use Batch Updating
• Work With 3rd-Party Vendor Components
• Access the File System of the Server
  

Target audience

Students should have a good working knowledge of Active Server Pages, gained through experience or attendance on an introductory level course

Course content

Introduction The Database Used for the Class • The Laundry Detergent Company Site • File Naming Convention

File Conventions Connection Pooling • Dynamic Connection Strings • Default METHOD and ACTION values

Advanced Data Drill-Downs An Example of Passing Data via the QueryString • Example: Drilling Down with Database Data • Using Drill-Downs to Reformat Data • Exercise 1: Displaying the Clients in a Column-Sortable Table

Displaying Variables Example: drillvariables.asp • Exercise 2: Displaying Variables in the Column-Sortable Table • variableshow.inc

Multi-Table Queries Example: Orders Listed by Client Name

Displaying a Portion of the Recordset Example: Displaying the next 5, 10, or 15 records: • A Note About Process • Exercise 3: Displaying the next X records in the Database

Password Protection with Session Variables Example: Pages with Password Protection • Exercise 4: Adding Password Protection To Your Pages

Using Stored Procedures Creating a Stored Procedure in the Database • Advantages of Stored Procedures • Exercise 5: Using Stored Procedures

Using Stored Procedures to Insert and Update Example: the update_client Stored Procedure • Exercise 6: Using a Stored Procedure to Enter Clients into the Database

Working with the File System in ASP The FileSystemObject • Creating or Opening a Text File • Methods of the TextStream Object • An Example: Building a Personal HTML Page • Exercise 7: Storing Text to a File • The File Object • The Folder Object • Exercise 8: Working with Files and Directories

Processing File Uploads Obtaining a Component for Processing File Uploads • The AspUpload Component • Building an HTML Form that Supports File Uploads • Processing the File on the Server with AspUpload • Processing Files and Entered Text • SetMaxSize • Manipulating Files via AspUpload • Creating a New Directory • Restricting Your Upload to Certain File Extensions • Exercise 9: Building a Resume Submission Interface

Batch Updating Opening the Recordset for Batch Updating • Editing the Records Row by Row • Updating the Batch • So Why Use Batches? • A Few VBScript Functions • Exercise 10: Implementing Batch Updating

Using rs.Update Instead of INSERT What's Happening Here?

Form Validation with Server-Side JScript and Regular Expressions Server-Side Form Validation with JScript • Exercise 11: Completing a Client-Side/Server-Side Form Validation Application

Transactions in ASP Handling Errors • Exercise 12: Catching Database Errors via Transactions

Creating Message Boards Part 1: Creating HTML Files • Creating the Database • The Interface • Exercise 13: Building a Moderated Message Board

Appendix A: A Brief Examination of clientdetails.asp

Appendix B: Regular Expressions Creating and Executing a Regular Expression with exec()• Special Characters for Pattern Matching • Escape Sequences for Special Characters • Specifying Ranges in Patterns • Matching a Specified Number of Occurrences • Character-Range Escape Sequences • Matching at the Beginning or End of a String with ^ and $ • The Word-Boundary Pattern Anchors: \b and \B • Ignoring Case with the iModifier

Appendix C: Common VBScript Functions

Appendix D: Recommendations for Further Reading

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today