ASP Advanced

ASP structure
Learn how Active Server Pages work.
The Application object - storing global data.
The Session object - setting timeouts, clearing data.


Reading and Writing from databases.
Creating a connection to an Access database.
Using a simple SQL query to create a record set.
Using Access to create and verify your SQL.
Reading off the recordset into your HTML page.


Create a password protected login page.
Create a web page where users type user name and password.
Checking password against a database list.
Redirecting user to success or failure pages.


Create a filterable listpage generated from a database.
Create a HTML table using your database recordset.
Create dropdown selections built from a database list.
Making your dropdown filter your list.


Manipulating data using vbscript.
Validating a form.
Using vbscript to manipulate times, dates, numbers and text.
Programing skills, arrays, collections, string functions.
Debugging vbscript, tracing errors.


Extra topics:
Create a numeric hit counter using the Textstream.
Creating a database driven hit counter which stores IP addresses and times.
Using the FileSystemObject to edit and organise files and folders via a webpage.

 

 

 

Course Overview:

Discover the more advanced features of ASP. Create live web pages built from databases, use ASP to let users login, view dynamic lists, and validate forms.

 

Course Duration:

1 Day

 

Course Pre-requisites:

It is assumed you have a good understanding of the subjects covered in the ASP introductory course.

 

At the end of this course
you will be able to:
  • Learn the structure of ASP.
  • Read and Write from databases via a webpage.
  • Create a password protected login page.
  • Create a filterable listpage generated from a database.
  • Learn how to manipulate data.
  • Extra topics: Create text files, hit counts, file organisers.

Price Band:

 Specialised