SF Bay Area
ASP with VBScript offers many powerful features. This course will train you in some of the most important features, including: persistent session and application variables, file input/output, and database integration.
Using the Response Object
Before a browser receives the HTML of a web page, it accepts various "headers" sent from the server. These headers specify whether the data to be received is an image, an HTML page -- or an instruction to the browser to redirect to another web site or to store a cookie. We will show you how to send these instructions to the browser using the "Response object", which does most of the hard work for you. These headers allow you to store cookies on a browser and redirect the browser to a different web page. You will also learn how to abort processing of an ASP using the Response object.
Subroutines and Functions
Often you will need to perform a sequence of instructions more than once in the same ASP. Subroutines and functions allow you to define your own commands, and then invoke them one or more time on a page. This course will present some examples of subroutines and functions, and show you how to create them.
Session and Application Variables
You can retain information about users between visits to your site using session and application variables. This course will train you in how to create and manipulate these variables and discuss their typical uses. This course will also examine the special global.asa file that contains code that is triggered when the web server starts or new sessions begin.
Every language has a means of manipulating files on the hard drive, and VBScript is no exception. We will show you the basics of reading and outputting a text files' contents, and also how to write to a file. Using these techniques, you will be able to create a guestbook ASP.
Structured Query Language (SQL) Basics
A separate language is used within ASP to manipulate records in a database. This language is SQL, and is standard among many database programs. Before getting into the ASP integration, we will explain and illustrate the four basic SQL instructions: SELECT, UPDATE, INSERT, and DELETE. This training exercise will give you a chance to try these commands on a sample database using a freeware database client.
Database Integration in ASP
In order to use SQL to retrieve a recordset from a database, or to make deletions/updates/inserts to a table, you need to first create an ASP "connection object". This course will show you how to instantiate these objects in an ASP and the various properties and methods associated with them.
Executing SQL in ASP and Returning Recordsets
After learning some SQL and creating a connection object, you will be ready to create an ASP that inserts, updates, and deletes from our sample database. Going one step further, this course will show you how, using a "recordset" object, you can select records from the database that match certain criteria, and then output them in your ASP.