Scott/Jones · Scott/Jones · Scott/Jones · Scott/Jones · Scott/Jones · Scott/Jones · Scott/Jones · Scott/Jones

Home | Textbook Catalog | Order Book | Syllabi

 

Save 12% over most
bookstore prices by ordering
directly from Scott/Jones!

Developing Web Applications with Active Server Pages

by Thom Luce
(Ohio University)
 

Level
Introductory, with minimal assumptions about student prerequisites.

Scope
Concise so it can be used with other WWW developer texts covering Java or JavaScript or HTML or . . .

Pedagogy
Luce is a college professor who teaches ASP to college students! This is not a trade book! Clear, well-written, at a basic level.

  • A single, evolving example application using ASP runs throughout the book. By the end of the book students have developed at least one full working application.
  • A few shorter step-by-step exercises also included.
  • Emphasis on "hands-on", not theory or reference.
  • Class-tested by the author and at Coastline Community College during development.
Each chapter concludes with
  • Summary
  • Key Words and Concepts
  • Guided Exercises

Instructors' CD includes

  • All examples programs (ASP and HTML) cited in text
  • Sample databases used in text
  • Supplementary text with figures, sample programs and some exercises covering
  • Intro to HTML
  • Nested Loops
  • Date Functions
  • Two dimensional arrays
  • FileSystemObject
  • Solutions to all exercises
  • Answers to questions asked in text
  • PowerPoint slides for each Chapter
Table of Contents

Chapter 1—An Introduction to ASP and VBScript
Introduction
A very brief history
How the Web works
A few problems with Web development
Getting around some of the problems
Scripting
A brief introduction to IIS objects
VBScript
Programs
Variables
Declaring variables
Variable names
Assigning values to variables
Arithmetic operations
A very simple Active Server Pages example
Data sub-types and data conversion functions
Making decisions
The IF statement
IF-ELSE-END IF
Relational operators
Logical operators
Logical functions
A simple validation example
If-elseif-end if
A more detailed example
A final word on variable names
One Last Sample Program
Exercises

Chapter 2—The Response Object and Lots More VBScript
Query Strings
The QueryString Collection
More on the Response Object
The Response buffer
Manipulating the Response buffer
Response.end
Response redirection
An Example
Error messages and debugging
VBScript Functions and Formats
Int and Fix
Round
Abs and Sqr
FormatNumber, FormatCurrency, FormatPercent
Argument
Format and Function Example
Loops
For Loops
Nested For Loops
String Functions
Do While Loop
String Processing Example
Date and Time Functions
Exercises

Chapter 3—Developing an Application with Arrays and Sub-Procedures
Web Applications
Multiple Pages
A stateless environment
A Sample Visual Basic Application
Problems porting the application to the Web
A Web-based Login and User Data application - Version 1
Part 1—Login.asp
Part2—Main.asp
Part 3—Update.asp
Arrays
A Sample Application Using Arrays
Sub-Programs
User defined sub-procedures
A very simple sub-procedure
Another simple sub-procedure
User defined functions
Two Dimensional Arrays
A function using a two-dimensional array
A Web-based Login and User Data application, Version 2
Problems with Version 1
The new approach
Two documents, multiple paths
The revised Login.asp combined with Main.asp
A sub-procedure to generate the login form
Using the sub-procedure where needed
Passing data to the revised Update.asp
The Revised Update.asp
Exercises

Chapter 4—Cookies, Applications and Sessions
Cookies
Overview
Setting Cookies
Using Cookies
A Web based Login and User Data application—Version 3
With Cookies
Login3.asp
Update3.asp
A final note on Cookies
Applications and the Application Object
Definition of a Web Application
Duration of a Web Application
The Application Object
Global.asa
Sessions and Session Objects
Sessions
The Session Object
Sessions and Global.asa
Working with the Session Object
A Sample Application using the Application and Session Objects
The application's global.asp file
Calculating and displaying the results
A Web based Login and User Data application - Version 4 with Session variables
The login
Server-Side Includes
The update
Exercises

Chapter 5—Database Access
Introduction
Databasics
ODBC
ASP and Database Access
The Connection object
The RecordSet Object
A Guest Book Example
Adovbs.inc
Opening a Recordset
Database cursors
Lock type
Adding a new record to a Recordset
Updating a Recordset
Closing the Recordset and Connection
Reading the Guest Book
Opening a Recordset - no cursor or lock type specified
Looping through a Recordset with a known number of columns
Reading the Guest Book, Version 2
Some problems referencing record set data by name
Referencing record set data by number
Determining the number of fields in a record set
Looping through a Recordset with a unknown number of columns
Controlling data in a record set
Dynamically creating an HTML SELECT list
The For Each loop
Selecting fields to include in the record set
The Recordset Source property
Filtering a record set
Creating the sort criteria
Setting the Recordset's sort property
Opening the selected, sorted and filtered record set
Exercises

Chapter 6—More Database
Relationships between objects and tables
One to One
One to Many
Many to Many
Implementing Relationships
Implementing a One to One relationship
Implementing a One to Many relationship
Implementing Many-to-Many relationships
Relational Integrity
Accessing Data from Related Tables
Using a Predefined Query
Using Data from one Table to find Data in Another Table
Two tables
Three tables
SQL join
More about the SQL SELECT statement
Column Selection
SQL functions (min, max, etc.)
Ordering
Filtering (Where Clause)
Joins
Error Trapping
Transaction Processing
A Web based Login and User Data Application - Version 5 - Using Database
Login5.asp
Returning User
New User
Update5.asp
Exercises

Appendix A—Reserved Words

ISBN 1-57676-061-8 (300 pages)

Home | Textbook Catalog | Order Book | Syllabi


Scott/Jones Inc., El Granada CA
Website maintenance & updating by
Jane Scott/Jones.
Updated
January 16, 2004