In this lab you will create a self-referencing page
that allows searching of all the products in your catalog. This page
will allow the user to enter a keyword or phrase (multiple adjacent words)
describing a product. Your page will then return a list of all
products in your catalog that include the keyword/phrase in the product
name or description, along with a link to the the appropriate product.asp
page providing all details about the product.
- You should create (insert) (You can use the linked database you made
in last lab to do this!)
- A single record in the catalog table describing your catalog.
You should use the CatalogID that matches your class
- Twenty (20) Products. Make sure that the CatalogID of the
records you insert matches the CatalogID you inserted! All of the
fields in the table should be filled out with reasonable numbers.
- Your page should be called search.asp
- Search both the ProductName and ProductDescription fields--don't
forget about wildcard searching.
- Your search should filter out all but your own catalog items! e.g.
Your where clauses should contain (CatalogID = ###).
- Your output view should provide at least the product name, stock on
hand (see next bullet), and price. The product name should be a link to the relevant
product.asp page for that product.
- If the amount is stock is less then or equal to zero, you should
display "Out of Stock". If not, you should display
"In Stock". You should write a function to do this.
- Display only five records per page. Use paging as discussed in class
to display long lists of results.
- Make sure your page follows the form design guidelines discussed in
This lab is worth 20 points and due on November 4th. When you have
completed the lab, send an email to Chris
Allen indicating you are done and providing the external URL to your
Valtara Digital Design http://www.valtara.com/csc123/
Copyright 1999, 2001, Valtara Digital Design, Blitzkrieg Software