Web Development - William M. Pegram

This schedule will be revised throughout the course. Chapter references are to Beginning Active Server Pages 3.0

Student Pages: Darcy, Geoff, George, Laura, Meron, Nakiah, Rene

Date	Topics	Homework Due
9/5	Instructor Meetings with Each Student Objects, Properties, Methods, Events (Ch. 6) Why Use Server-Side Scripting? FTP Using Browser (FTP Instructions) Server Behavior when page request doesn't include filename
9/7	Request and Response Objects (Ch. 7) FTP Using FTP Client CoreFTP	Questions on Chapters 1-5 Table, Form, and ASP Exercise
9/8	Applications, Sessions, and Cookies (Ch. 8) - example of global.asa file Inclass development of Login pages using Session Variables - Login form, Login Action (code), Page to be protected (try it, code), File included in pages to be protected (code), Code from all 4 pages	Creation of Index Page and FTP Exercise
9/12	Error Handling (Ch. 9) Scripting Objects (Ch. 10) - Dictionary Object, FileSystemObject - displaying a file directory with links to files (code), displaying ASP code of a file (code)
9/14	Scripting Objects (cont.) - Text Stream Object ASP Components (Ch. 11) - Ad Rotator Component - display page (code), scheduler txt file, redirector file (code), display clickthrough count (code) Recoding of Login Page to provide for return to page initially sought - file included in pages to be protected (code), login action (code)
9/15	ASP Components (cont.) - Content Linking/NextLink and Brower Capabilities Components Displaying List of Microsoft ASP Components and their Methods/Properties through VBA Editor in Word, Excel, or Access
9/19	Database Concepts (table, records, fields, primary key, foreign key, relational database, referential integrity, normalization) Creating Tables in Microsoft Access ASP and Data Store Access (Ch. 12) - connection via connection string (code), connection via data link file (code, code of datalink file), connection (data link file generates connection string which is then pasted (code), connection via system data source name (code), connection via connection string using Server.MapPath (code) Using Recordsets (Ch. 13) - ADO Constants, Cursor Types, Locking, Recordset EOF & BOF Properties, MoveNext and related Methods
9/21	Using Recordsets (cont.) - Bookmarks, Find method, Filter Property, Fields collections, GetRows Advanced Data Handling Techniques (Ch. 14) - Putting database connection (code) and database close (code) into include files , SELECT SQL and Command Object Execute method, accessing ADO constants through metadata statement and SSI, SELECT statement with related tables, SELECT statement with related tables and criteria to select records, UPDATE statement
9/22	Insert and Delete SQL statements, using input from forms (dynamic SQL) - form, form with output in table, form with output in tables, with HTML and ASP intermixed and passing primary key in link to delete action page (code) (Ch. 14)
9/26	Using Recordsets to insert, update, and delete records rather than SQL statements (Ch. 14) Put query in Access rather than ASP Using ASP to dynamically populate form from database, using ASP to pass parameter to Access parameter query Function to write out table (code) Debugging on Projects
9/28
9/29		Project

Revised: September 28, 2006. Comments to William Pegram, bill@billpegram.com