Introduction

In this project you will continue working on integrating Web pages with the contacts.mdb database.  This project applies what you learned in lessons 7 & 8 and Project 4, so be sure to do those before you try this project.  These labs are somewhat complicated, so it wouldn't hurt to repeat them a few times for practice until you understand the concept of sending a URL parameter and moving to a specific  record or filtering the recordset based on that parameter.

For this project, you will create a page to add a record and a page to update a record in the Contacts database.

This assignment will be easier if you view my example before you begin.  See my add page and my list of links (click update to go to update page).

What to Do

1. You should already have a working connection (connContacts - created in the previous).

2. Open add.asp.  Use the Record Insertion Form Wizard to create a form to add a new record.  Save, upload, and test.

3. Open list.asp and add a link to add.asp at the bottom of the page.
   

4. Add the word "update" after the link description -- make sure this is part of the repeat behavior. Save, upload, and test.  When you test, you should see update next to every record.
   
   
5. Select the word update and add a Go to Detail Page server behavior.  You will go to update.asp with num as a parameter.  You can name the parameter whatever you like, but remember the name since you will need it in the next step. 

   Save, upload, and test.  When you test, click the update link and examine your query string. 

6. Open update.asp and create a recordset with a filter so that the page only displays the record of interest (parameter passed in query string matches num in recordset).
   
7. Use the Record Update Form Wizard to create a form that will update a record.
8. Save, upload, and test.  When you click update on list.asp, you should see the appropriate record appear.  You should be able to change values in fields and update your record.  Your file should work like my example. 
   

Submitting work

• Add a link to this assignment from 213homework.htm.
• Upload your files to the cis2 server. Don't forget to TEST YOUR WORK on the server!
• Submit your URL to Blackboard. 

Grading - 60 points