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 5 & 6 and the previous project, so do those first or this project won't make sense.

For this project, you will use the connContacts connection you created in the previous project.  You will create a recordset, display dynamic data on a page (including a dynamic link),  and add a repeat behavior to display a list of all records in contacts.mdb.  Before you begin, view my example.

Remember to preview the page after each step.

What to Do

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

2. Open list.asp and create a simple recordset (rsLinks) that includes all the fields (columns). If you prefer, you could also copy and paste this recordset from detail.asp.  Test the recordset, then save and upload the file. 

3. Add dynamic data to display the firstname & lastname fields followed by the words Web Site.  If you wish, you may put these into a table, but it isn't required.
   
   
4. Make dynamic links by binding the URL field to the words Web Site.   See project 3 instructions if necessary.  
   
5. Add a repeat behavior to display all records in the recordset.
   
   
6. Upload and test your work.  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 213homework.htm to Blackboard.  When I grade, I will click the absolute link to go to your work on the cis2 server, so you can make changes up to the time I grade it.

Grading - 60 points