Programming (ASP)

The main focus of our programming chapter is the study of ASP, Active Server Pages. ASP web pages need to be hosted on a Microsoft Web server like Windows 2000 or 2003 server with IIS, Internet Information Server. I have been teaching myself ASP since Aug. of 2000 when I built my first online ASP service. I created a search service for our school to locate and lookup teacher email addresses. This had been a problem at that time, and I wanted to solve the problem with an ASP solution. This application was my first attempt at an ASP service. Try it out.

If you are really interested in ASP, check out this ASP photo sharing web site I built in December 2002. To create this site, I bought a pre-built ASP application and modified it for the yachting community! Very cool.

CHECK OUT A PICTURE OF THIS CHAPTER!
(Wow, that is a lot of writing!)

Basic lessons in ASP

1. Lesson # 1  Create a basic web form
   1. Learn how to create a basic web form.
   2. Learn how to send form data to an email address.
   3. Learn how to send form data to an access database.
       
2. Lesson #2  Create a simple Guestbook
   1. Learn How to make an ASP guestbook application!
   2. Follow the basic steps to create an access database.
       
3. Lesson #3  Design a basic Survey 1
   1. Learn how to create an online survey.
   2. Create SURVEY1 and use dropdown list and option buttons.
   3. Format the results page in a table.
   4. Create a hyperlinked field to a URL
       
4. Lesson #4  Sort the survey by Class Pd with a textbox
   1. How to sort your survey1 by class period
   2. How to create a new asp page
   3. How to insert a database results area.
       
5. Lesson #5  Sort the survey using a Drop-Box
   1. Use a web form drop-down box to query a database
   2. Drop-down box uses DISTINCT SQL query
   3. Drop-down box web form sends data to SAME WEB PAGE
   4. SAME WEB page displays the results of the drop-down box!
   5. Very COOL!
6. Lesson #6  Sort Using MULTIPLE Queries! (TEST TIME)
   1. Time to apply your learning, demonstrate your understanding!
   2. See if you can create this!
   3. You have the knowledge, now combine lesson #4 with lesson #5.
   4. Prove your understanding as your create a MULTI QUERY
   5. NO handout for this one, this is a TEST!
7. Lesson #7 Adding a User Login system
   1. Learn how to implement the Spooky Login Lite application
   2. Integrate a registration page.
   3. Lock pages with <%.....ASP CODE......%>
   4. Learn about database connection strings like db_conn.asp

   ---

ASP / Access Resource

1. http://frontpagemagic.com/
   1. Ward Cameron has some of the best writing and best tutorials on Access and ASP FrontPage. Every solution is outline in his writing. You must read his work.
2. http://support.microsoft.com/
   1. Microsoft's Support Center. Search for FrontPage and get the latest "How to" articles. Ask for help from the creators of FrontPage
3. http://www.outfront.net/
   1. Thomas Brunt has long been a leader in the FrontPage community. Read the SPOOKY LOGIN system he created. Also subscribe to his newsletter to keep up with FrontPage design.
4. http://www.frontpagetalk.com/forums/
   1. The biggest and the best online forum for FrontPage where you can really learn a lot about site design. If you have a question about any ASP issues, post your question in this forum and you will get the answers.
5. http://webwizguide.com/
   1. FANTASTIC free ASP code and applications that you can download and add to your web sites. Check this site out, it is great.
6. http://www.w3schools.com/
   1. The best online tutorials for ASP. Learn your syntax and how to structure your ASP code here.
       

   ---