Server-Side Web Programming with Active Server
Since many ASP applications make heavy use of date math, in this lab you will create an ASP page that calculates the amount of time between the current date and a date selected by the client. The client will also select the units to return (e.g., months, days, weeks, years) and which weekdays (if any) to exclude from the calculation.
Create a directory called "Lab04" in your class child web with two pages: default.htm and output.asp. Below is a screen snapshot of the data entry elements--your default.htm page should include these, although you will want to arrange them in a more attractive and user-friendly page. Your output.asp page should provide the user with the date they selected, the current date, the calculation they requested, and a link back to the input page.
As always, follow page design best practices and make your user-interface clear and easy-to-use.
This lab is worth 15 points and due on September 30th. When you have completed the lab, send an email to Chris Allen indicating you are done and providing the external URL to your pages.
Create a page in your Lab04 directory called "SQL2.htm". Using
the sample "Shop" database
discussed in class, your page should list the questions below and provide a
SQL statement (not the data) that would answer the question.
1. Write a query to show the customer #, name information, and the sale date and ship date for all orders
3. Show the count of the total number of products for each catalog and the catalog name.
4. For each order, write a query to summarize the sale by providing the total number of items, total price, and total sales tax.
Valtara Digital Design http://www.valtara.com/csc123/
Copyright 1999, 2001, Valtara Digital Design, Blitzkrieg Software