Computer Learning Zone CLZ Access Excel Word Windows

Knowledge will bring you the opportunity to make a difference.

-Claire Fagin
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
 
 
Courses - ASP - Active Server Pages - Index

You can use this index to see what topics are covered in each class. If you are looking for a particular course topic, you can use your browser's search function to find that topic. If you are using Microsoft Internet Explorer, you can open the Find feature in your browser by pressing CTRL-F or clicking on Edit > Find.
 
ASP 101


96 Minutes

1. Definitions
What is ASP
What is a Script
Client-side v. Server-side

2. First Script
Loading my Web editor
Creating a new folder
Creating a new page
default.asp
asp vs. htm files
Switching to HTML view
<% and %> tags
Time() function
Viewing our asp script live
Date() function
List of ASP Web Hosting Providers

3. Basic Commands
Response.Write
String Concatenation &
Multiple command lines
Text strings
If/Then Statement
Setting a Variable's Value
Embedding HTML in ASP
If/Then/Else
DatePart function
Comments in your code

4. HTML Tags in ASP
Bolding Text in ASP
Creating hyperlinks
Changing links in ASP
Single quotes inside double quotes
Double-double quotes

5. Variables & Loops
For/Next Loop
While Loop
String Text vs. Variable Values
Dim variables
For/Next Step option

6. Math
Addition
Subtraction
Multiplication
Division
Order of Operations
Integer Division
Modulus
Round Function

7. If / Then / ElseIf
Storing Time/Date in a Variable
DatePart code list
Line continuation character
ElseIf option
Inline math with a variable
Using actual times in code
#11:00 pm#

8. Processing Form Input
Creating an HTML Form
Creating Text Boxes
FrontPage Web Bots
Form Action Property
Create the Process.asp page
Request Command

9. QueryString
What is a QueryString
Request.Form
Request.Querystring
Reading the QueryString
Reading Multiple Values
? and &
Display Entire Querystring
Name / Value Pairs
Dynamic Web Content

ASP 102


72 Minutes

1. Variables
Variable Types
Dim a Variable
Explicit Declaration
Option Explicit
Variable Naming Conventions
Rules for Naming Variables
Constants

2. Arrays
What are Arrays?
Dim an Array
Assign values
Loop to display items
Array Function
Weekday Function

3. Select Case Statement
Select Case
Case
Case Else
Select Case v. If Then

4. More Loops
Do While Loop
Do Until Loop
Exit Do
For Next Step
Step Negative
For Each in an Array
Nested Loops
Nested If/Then Statements
Exit For

5. Subroutines
Creating a Sub
Passing Parameters to a Sub
Creating a Function
Passing Parameters to a Function
Returning a value from a function

6. Typecasting
Integer Type
CInt
Double Type
CDbl
Long Integer Type
CLng
Single Type
CSng
Boolean Type
True, False
CBool
Currency Type
CCur
Date/Time Types
CDate
String Type
CStr

7. Date & Time Functions
FormatDateTime
vbGeneralDate
vbLongDate
vbShortDate
vbLongTime
vbShortTime
Adding Dates & Times
Using Simple Addition
DateAdd function
Values for DateAdd Function
Difference between two dates
DateDiff Function
DateSerial
TimeSerial
DatePart
Year Function
Month Function
Day Function
MonthName Function
Weekday Function
Hour, Minute, Second Functions
WeekdayNames Array

ASP 103


76 Minutes

1. Formatting Numbers
FormatCurrency
Optional Parameters
Leading Zeros
Parentheses for Negative Values
FormatNumber
FormatPercent

2. Math Functions
ABS Absolute Value
INT and FIX
EXP and LOG
HEX and OCT
Trig Functions: SIN, COS, TAN, ATN
Generating Random Numbers
Randomize
Rnd
Making sense of Rnd function
Round function
Sgn function

3. String Functions
UCase & LCase
Trim, LTrim, RTrim
String function
Determining the length of a string
Len Function
StrComp function
Left, Right, Mid functions
InStr and InStrRev functions
Replace function
Split and Join functions
UBound and LBound functions
ASC and CHR functions

4. The Response Object
Writing a %> character in ASP
Quotes inside strings problem "" or '
Server.HTMLEncode
Response.Buffer
Response.Clear
Response.Flush
Response.End
Checking a password
Response.Redirect
Response.Expires
Response.ExpiresAbsolute
Response.Cookies will be covered later

5. Different Form Fields
Create a Form
Difference between GET and POST
Create a Textbox
Create a Text Area
Create a Checkbox
Initial State vs. Value "ON"
Create an Option Button
Create a Drop Down Box
Dropdown vs. List Box
Create the display-results.asp page

ASP 104


72 Minutes

1. Related Checkbox Values
Creating Multiple Related Checkboxes
List of Magazines to Subscribe to
List Sent as One Field
Comma-Delimited Text Fields
Using the Split Function
Break up Comma List into Array
Displaying with For Each Loop

2. The Request Object
Request.ServerVariables
What Browser and OS is your visitor using?
HTTP_USER_AGENT
Where did your visitor come from?
HTTP_REFERER
See all of the headers
ALL_HTTP
Environment Variables
QUERY_STRING
What is the URL of the current page?
URL Variable
PATH_INFO
What is the physical path of the page?
PATH_TRANSLATED
What is the physical path of the web?
APPL_PHYSICAL_PATH
Name of the server?
SERVER_NAME
What web server software is installed?
SERVER_SOFTWARE
Loop through the ServerVariables collection

3. Cookies
What are Cookies?
What are they used for?
Why are they good? Bad?
Problems with cookies
Creating a cookie - storing information
Response.Cookies
Reading the cookie data - reading info
Request.Cookies
Cookies Expire when Browser Closed
Cookie .Expires property
Cookies with Keys

4. Session Variables
What is a Session variable
What is it used for?
How to store a Session Variable
How to read a Session Variable
SessionID
Session.Timeout
Session.Abandon
Sessions can store Arrays
Session.Contents

5. Application Variables
What Application variables are
What are Application variables used for
Storing an Application Variable
Reading an Application Variable
Application.Lock and .Unlock

ASP 201


72 Minutes

1. Server-Side Includes, Part 1
What are Server-Side Includes
#include page
Creating a Header and Footer Page
Using the Header in multiple pages
Changing the Header info dynamically

2. Server-Side Includes, Part 2
#include virtual
Including files in different folders
Using Includes for functions and subs

3. Files & Folders, part 1
Creating a Server Object
Server.CreateObject
Scripting.FileSystemObject
Server.MapPath
FileExists
Set = Nothing
Destroying an Object
Check to see if a File Exists
Check to see if a Folder Exists

4. Files & Folders, part 2
File Properties
- Attributes
- DateCreated
- DateLastAccessed
- DateLastModified
- Drive
- Name
- ParentFolder
- Path
- ShortName
- ShortPath
- Size
- Type
Additional Folder Properties
- Files
- IsRootFolder
- Subfolders
Loop through the Files in a Folder
The Files Collection
Loop through the Subfolders in a Folder
Subfolders Collection

5. Read a Text File
OpenTextFile
ForReading (1)
AtEndOfStream
Server.HTMLEncode
Read
ReadLine

ASP 202


72 Minutes

1. Writing Text Files
Why you can't just write to a file
Setting File Permissions in Windows Server
Open ForWriting (2)
Open ForAppending (8)
CreateTextFile
Setting Folder Permissions on your Server
Allowing users to create files

2. Username Password Logon
Creating a Username,Password List
Submitting with a Logon form
Looping through the password list
Finding the correct user/pass combination
Split function

3. Global.ASA File
Session_OnStart
Session_OnEnd
Application_OnStart
Application_OnEnd
Tracking how many users are on your site

4. Error Handling
On Error Resume Next
Err.Number
Err.Description
Discuss ASPError (Not Covered)

5. Sending Email, Part 1
CDO.Message Object
Subject, From, To
TextBody
Send
vbNewLine
CC, BCC
Sending HTML Mail
HTMLBody
Send a Web Page
CreateMHTMLBody
Send an Attachment

6. Sending Email, Part 2
Using an SMTP Server
Setup Constants
List of Schemas
CDO.Configuration
Fields & Items

ASP 301


76 Minutes

1. Setting Up a Database
What is a Database
What is Microsoft Access
Creating an Access MDB File
Different Access Components
Creating a Table
Building a Table in Design View
Different Field Types
Create a Customer Table
Saving Your Table

2. Uploading Database to Web
Creating a _Databases folder
Viewing Hidden Web Folders
Uploading your Database
File and Folder Permissions
FrontPage Database Connections

3. Connect to Database
Specify a Database Path
Server.MapPath
Create a Connection Object
ADODB.Connection
Specify a Provider
Microsoft Jet Database
Open your Database Connection
Create a RecordSet Object
Specify a Table Name
Display a Field
Close Your Connections

4. Using ODBC Data Sources
Connecting to Non-Access Databases
ODBC Data Source Administrator
Creating a Database Connection
Specifying a DSN Name
Changing Your ConnectionString

5. Loop Through Records
Display All Customers
Endless Loops
RS.MoveNext
Server.ScriptTimeout
Displaying Records in an HTML Table
How HTML Colors Work #FFAACC

6. Adding Records
Create a Form to Add a Customer
Setup ASP Code for Adding Records
Checking for Required Data
RS.AddNew
Add a New Record to our Table
How to Open Recordset for Updates
Brief Discussion on Record Locking

ASP 302


73 Minutes

1. Display a Specific Record
Selecting One Customer
Querystring ID Value
Fields Collection
For Each Field in Fields
Loop to Find Requested Customer
CLng
QueryString Values Are Text Strings
Create a Hyperlink From Customer List
vbNewLine for Cleaner HTML

2. SQL Statements
Using SQL In Our Recordsets
SELECT, FROM
Selecting Specific Records
WHERE
Sorting By Specific Fields
ORDER BY
Selecting All Fields
SELECT *
Sorting Our Customer List
Creating Hyperlinks to Sort the Table
Click on a Header to Sort That Column

3. Edit a Record, Part 1
Removing Duplicated Code
Database Connect, Disconnect Pages
Are We Adding or Editing a Record?
If Editing, Read Existing Data
If Adding, Load Defaults
Display Existing Data in Entry Form

4. Edit a Record, Part 2
Adding a Hidden ID Text Box
ID=0 Means We're ADDING
Updating Field Values
Link To Edit Record
Link To Add New Record

5. Delete a Record
RS.Delete
Deleting a Customer
Are You Sure Page
Specifying Multiple QueryString Parameters
Server.URLEncode
Using Basic JavaScript
Popup an "Are You Sure?" Box
OnClick Event in Hyperlink
Return ConfirmDelete()
JavaScript Confirm Command

ASP 303


80 Minutes

1. Logon Security, Part 1
Opening an Access Database Online
Ramifications of Losing Live Data
Logon Form
Using Strings as SQL Statement Parameters
Looking up a Username
Checking Password
What to do if Username invalid

2. Logon Security, Part 2
Process a Valid Logon
Remembering a Logged In User
Session Variables for User Info
Security Check for Each Page in Web
Include Page
Logoff Page
Hide Links if Not Logged In
Display Logon Info on Main Menu
Display Different Menu Items if Logged On

3. Search Form, Part 1
Searching for Customers by Last Name
Searching by Start of Last Name
SQL Wildcards % _ []

4. Search Form, Part 2
Search for Multiple Fields
Building a Dynamic SQL Statement
AND Conditions
Searching for Dates #1/1/90#

5. Dropdown Boxes
Creating a Dropdown Box with Static Options
Setting the Selected Value
Displayed Option vs. Value

6. Menubar Header
Create a Header Menu Links Bar
One-Time Message Displays in Header

ASP 304


81 Minutes

1. Contact Management
Creating a Contact Table
Primary v. Foreign Keys
Relational Databases
Creating the Contacts List Page
Listing Contacts For Specific Customer

2. Displaying Multiple Tables
Showing Customer Data on Contact Form
Opening a Second Recordset Object
Showing Customer Name on Contacts
Link to Customer Record
Creating a DLOOKUP Function
Looking up Values from another Table
Local v. Global Variables
Variable Scope
Dim Local Variables in a Function

3. Add Contact Form, Part 1
Changing IDs to a Simple Counter
Creating the Add/Edit Contact Form
Convert Add Customer to Add Contact

4. Add Contact Form, Part 2
Processing Submitted Data
Creating a Dynamic Dropdown List
Filling a Customer Dropdown with Data
Setting the Selected Record

5. Add Contact Form, Part 3
Create a TextArea for Notes
Create a Checkbox for Callback

ASP 310


Coming Soon!

Interested in learning more ASP? See below for upcoming topics, and make your voice heard... tell Richard to make ASP 310 as soon as possible.

Shopping Cart... Anyone?

 

Topics yet to be covered:
  • Custom Error Handling - ASPError
  • Server.Execute and Server.Transfer
  • Detailed Inspection of Recordset Object
  • Scrollable CursorTypes
  • Different Types of Record Locking
  • Using Stored Procedures (SQL Server) and Queries (Access)
  • The Drive Object (drive space free, etc.)
  • File Uploads (pictures, documents, etc.)

Plus, if anyone is interested in learning how to create a full eCommerce site complete with a product list, shopping cart, and order processing, let me know. After taking ASP101 to 304, you have the tools to do it, but you just need to know how to put it all together.

If you are anxious to see tutorials for any of these topics, please email me and let me know! Let me know exactly what you want to see.

 
 

 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 11/1/2024 10:30:51 PM. PLT: 0s