Skip to Content

Training Resources

Current Training Schedule

Class Registration Form

Get Adobe Reader

expand or collapse the menu Accessibility

expand or collapse the menu Web Development

expand or collapse the menu Adobe / Macromedia Web

expand or collapse the menu Programming

expand or collapse the menu Databases

expand or collapse the menu Professional Courses

expand or collapse the menu Adobe

expand or collapse the menu Microsoft SharePoint

expand or collapse the menu Technical

expand or collapse the menu Geographic (GIS)

expand or collapse the menu Microsoft Office

Training Resources

Current Training Schedule

Class Registration Form

Get Adobe Reader

Active Server Pages - Advanced

2 day course

View Detailed Outline in PDF format

Get Adobe Reader

In this course, you will learn to use sophisticated programming strategies and advanced features to add polish, speed, and efficiency to your Active Server Pages web applications. This advanced class builds on skills acquired through our introductory course to provide an in-depth look at ASP. In this course, you 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 your web site. In addition, you will work with other components, including those that ship with ASP as well as those you can purchase from 3rd party vendors. You will also learn how to implement advanced drill-downs, debug ASP code, use batch updating, work with stored procedures, and more.

Course Topics:

(for a full detailed outline, visit our PDF link above)

Introduction

  • Databases
  • File naming convention

File Conventions

  • Connection pooling
  • Dynamic connection strings
  • Default METHOD and ACTION values

Advanced Data Drill-Downs

  • Passing data via the QueryString
  • Drilling down with database data
  • Using drill-downs to reformat data
  • Displaying data in a column-sortable table

Displaying Variables

  • drillvariables.asp
  • Displaying variables in a column-sortable table
  • variableshow.inc

Multi-Table Queries

Displaying a Portion of the Recordset

  • A note about process
  • Displaying the next x records in a database

Password Protection with Session Variables

Using Stored Procedures

  • Creating a stored procedure
  • Advantages of stored procedures
  • Using stored procedures to insert and update

Working with the File System in ASP

  • The FileSystemObject
  • Creating or opening a text file
  • Methods of the TextStream object
  • Storing text to a file
  • File object
  • Folder object
  • Working with files and directories

Processing File Uploads

  • The AspUpload component
  • Building an HTML form that supports file uploads
  • Processing files and entered text
  • SetMaxSize
  • Manipulating files via AspUpload
  • Creating a new directory
  • Restricting your upload to certain file extensions

Batch Updating

  • Opening the recordset for batch updating
  • Editing the records row by row
  • Updating the batch
  • Advantages of using batches

Using rs.Update Instead of INSERT

Form Validation with Server-Side JScript and Regular Expressions

  • Server-side form validation with JScript
  • Client-side/server-side form validation applications

Transactions in ASP

  • Handling errors

Creating Message Boards

  • Creating the HTML files
  • Creating the database
  • Using the interface

A Brief Examination of clientdetails.asp

Regular Expressions

  • Creating/executing a regular expression with exec()
  • Special characters and escape sequences
  • Specifying ranges in patterns
  • Matching a specified number of occurrences
  • Matching with ^ and $
  • Word-boundary pattern anchors: \b and \B
  • Ignoring case with the IModifier

Common VBScript Functions