599CD.com Working on Excel 2010 Videos   Mobile View
 
 
NEW Courses - Access Work Orders, Excel 2007 Level 5 dismiss
 
   
 

What's New?  |  Courses  |  Theater  |  Demo  |  Tips  |  Blog  |  Forums  |  Search  |  Help  |  Order

 
What do you want to learn today? 
 
 
Courses - Active Server Pages 303
Description: Advanced ASP 303
Running Time: 80 minutes
Pre-Requisites: ASP 302
Versions:
We use Standard ASP on a Windows Server. We also use Microsoft FrontPage 2003 for our Web editor. You can use any server or Web editor compatible with ASP.
 

 Click here for the Teacher's Outline
 

Major topics covered in this class:

  • User Logon
  • Securing Your Site
  • Create a Search Form
  • Dropdown Boxes
  • Menubar & Header for Your Site

We will begin this class by discussing web site security. What do you need to do on your ASP pages to prevent authorized use? We will add a User table to our database, and set up user accounts.

You will learn how to set up each sensitive page (such as a page on which data can be altered) so that someone needs to be logged in to access it. We'll track that information in Session variables.

Next, we will create a search form, so that your users can query your database. They will be able to search by First Name, Last Name, Customer Since, etc. You will learn how to perform a Wildcard search using SQL statements.

Your search results will be displayed in a table similar to our customer list, showing all of the returned records:

You will next learn how ASP handles dropdown boxes with static options. We'll pick a state from a list of states and you'll see how to store that information in the table. We'll learn the difference between the stored value and the displayed value - so that we can store "PA" but show "Pennsylvania" in the box, for example.

Finally, we'll create a proper site header for our web, complete with navigation hyperlinks and user logon information.

I'll also show you how to display "one-time" system messages to your users when specific events happen.

We're getting closer to being able to design a full web site with ASP. Now we know how to secure our pages, create a search form, a navigation bar, and handle dropdown boxes.

 
 


Try a FREE Demo Lesson

 

 Click here for the Teacher's Outline
 
 

Huge Discounts Available
When you purchase multiple classes together
Huge savings up to 50% off! Order Now.
 

Student Interaction: Active Server Pages 303

Richard on 8/20/2008:  ASP 303 covers User Logon, Securing Your Site, Create a Search Form, Dropdown Boxes, Menubar & Header for Your Site. See the complete outline here: http://www.599cd.com/site/courselist/asp/asp303/
Roberta Joudrey on 1/5/2009: I have a field in my database that contains maybe 200 words. I have set up my search box for that field and when I search for one word it finds all of the records that contain that word. I would like to know how to refine the results by searching for two or more words from that field.
Richard Rost on 1/20/2009: Roberta, that's going to just require a bit more work with your WHERE clause. You could make two or three text boxes on your search form and just say: "WHERE FirstName LIKE %" & Field1 & "% AND FirstName LIKE %" Field2 & "%" This will let you find all FirstNames that have BOTH search field 1 and 2 in them.
Audrey Palmer on 7/22/2010: how to download all the files used in this course?
Audrey Palmer on 7/22/2010: will this scenario for using username as a session variable work if you have multiple users, using the same username?
 
 

You may want to read these articles from the 599CD Blog:

 

 

Need Help
 
Do you have questions about Word, Excel, Access, Web Design, or computers in general? Just ask us anything you'd like. Click here for assistance.
 

Get Free Tips & Tricks
 

Join our mailing list today and get information on our Free Tips & Tricks Newsletter including free video tutorials, eBooks, live seminars, and more.

Email:
Name:
Type in the word to the left:
 
Your email will be kept 100% safe and will never be given to 3rd parties.
 


CLICK HERE for a FREE lesson



Order your first 599CD course now.
Your Satisfaction is Guaranteed!


Subscribe to our RSS FeedWhat's This?

599CD on Facebook  599CD on Twitter  Subscribe to RSS Feed  Add to Live Bookmarks  Add to My AOL  Add to MyYahoo  Add to Google Reader or Homepage    hide  help

599CD Home   |   Learn More   |   What's New?   |   Contact Us   |   Free Demo   |   FAQs   |   Order Now   |   Affiliate Program   |   TechHelp   |   MYOLP   |   Jobs   |   Downloads   |   Handbooks  (Text)   |    Mailing List   |   Lost Passwords   |   Referral Program   |   Online Poll   |   Corporate, Educational, Government, Non-Profit Sales   |   Message Forums   |   Testimonials   |   Privacy Policy   |   Free Gift CDs   |   Tips & Tricks

 
 

What's New  |  Home  |  Courses  |  Demo  |  Learn More  |  Contact  |  Order