| Getting started |
| |
What is ASP
Server-side vs. client-side scripts
VBScript and JavaScript
Requirements for running ASP
Internet Information Server
Personal Web Server
Defining a new ASP site |
|
| Connections |
| |
Databases
and dynamic sites
What is a database connection
Creating a DSN
Creating a DSNless connection
Connection string parameters
Dreamweaver's connection folder |
|
| Recordsets |
| |
What is a recordset?
Creating a recordset
Simple and advanced modes
What is SQL?
The SELECT statement
The ORDER BY clause |
|
| Display records |
| |
Adding dynamic content
to pages
Creating Repeat Regions
Using Recordset Paging
Using Show Region
Displaying the current page
Using Live Data View |
|
| Filtering records |
| |
The use of
variables
Setting default values
Setting run-time values
Naming variables
Creating the WHERE clause
Filtering numeric fields
Filtering text fields
Filtering date fields
Using wildcards |
|
| Searches and results |
| |
Creating search
pages
Designing and naming fields
Buttons and search forms
Get and Post methods
Passing parameters across pages
Go to Detail Page
Go to Related Page |
|
| Writing to databases |
| |
Insert Record
Naming form fields
Update Record
Repopulating the update form
Delete Record |
|
| Dynamic elements |
| |
Making HTML attributes dynamic
Dynamic text
Dynamic images
Dynamic links
Dynamic drop-down menus
Dynamic radio buttons |
|
| User authentication |
| |
Creating a registration page
Check User Name
Creating a log in page
Log In User
Restrict Access to Page
Log Out User
Using levels in authentication |
|
