ITEC 334 Fall 2008
Computer Programming in the Web Era

Active Server Pages Notes

Last Updated 10/24/08

Online Tutorial Orders Demo
Basics  Retrieve  Enter  Delete  Update  Other  XML

The ASP Environment and Scripting Basics

• The <% tag and ASP script layout
• Variables
• Loops: Factorial Calculation Example
• IF Example
• Creating Functions  [VBScript Built-in Functions]

Retrieving and Displaying Data

• The "connection" object, DSN, ODBC and the recordset
• Displaying a full database table
• Displaying part of a table
• (1, 2 & 3) Quick recordset displays
• Displaying part of a table with user input   [Demo: Products Customers Orders]

• Testing a DSN
• Displaying any table with any DSN
• Testing a database file connection
• Displaying any table with any database file name

• Delivery menu with both client-side and server-side scripts *
• HW 4a Displaying Data *

Entering New Data

• (1) Inserting a record with fixed values
• (2) Writing and embedding SQL INSERT query strings
• (3) Inserting a single record with user input  [Demo: Register Customer Place Order]
• (3) Inserting a single record with picklist  [Demo: Place Order wPicklist]

Deleting Data

Suggestion: don't delete more than one record at a time, unless you have to and you know what you are doing

• (1) Deleting a single record with fixed values
• (2) Writing and embedding SQL DELETE query strings
• (3) Deleting a single record with user input
• (3) Deleting a single record with picklist

Updating Data

• (1) Updating fixed values in a given record
• (2) Writing and embedding SQL UPDATE query strings
• (3) Updating a single record with user input
• (3) Updating a single record with picklist

Other ASP Programming Concepts

• Global settings, application and session variables - also see code for global.asa  [ASP Application and Session Objects]
• Timeouts and the redirect method - this script will redirect you to a login screen -- you will only be able to see this page after you log in through the class_global.asp script.
• Included scripts - this script will only work if you are logged in via the class_global.asp script. Otherwise it will re-direct you there.
• Password protection and user access and roles
• Loging out
• E-mail script
• Product catalogs with pictures, shopping cart and checkout
• Entering orders and order details (line items)
• Surveys: text boxes, check boxes and radio buttons

eXtensibe Markup Language (XML)

• Simple example: Books - hand coded in XML
• Simple example: Nutrition - hand coded in XML
• Creating XML documents with ASP
• Simple example: Books - created with ASP
• Createing XML from database data - Orders & LineItems