Asp guia practica

A Practical Guide to
Microsoft

Active Server Pages 3.0

By

Manas Tungare
www.manastungare.com

ACTIVE SERVER PAGES 3.0

About this guide ...
This practical guide aims to be a complete programming guide as well as a reference for the serious ASP programmer. It does not assume any prior knowledge of ASP, and starts from the ground up. The chapters are organized according to theincreasing complexity of ASP scripts that you will be writing. Simple scripts come first, and then the techniques needed for more complex scripts are covered. This is especially useful for the beginner who is usually inundated by long, boring technical dissertations in the first chapter of any book. Experienced programmers will also find this guide useful, for it contains the following references inone easy-to-locate booklet. VBScript Reference A complete documentation of all VBScript functions with the necessary information for using them. Ideal for those situations where you know what you want to do, but can't remember the function that will do it for you. SQL Reference This includes complete syntactic specifications of the Structured Query Language, along with examples to demonstrate theuse. ADO Reference A guide on ASP cannot miss out this quintessential section. It gives complete details on most of the objects in the ADO hierarchy.

The examples and samples used in this guide can be found on the web at: http://www.manastungare.com/asp Thanks to Pankaj Kamat for proofreading this document.

Copyright © 2000, Manas Tungare. http://www.manastungare.com/ Every effort has beenmade to ensure correctness & reliability of the information provided, however the author may not be held responsible for any errors that may have crept in.

2

ACTIVE SERVER PAGES 3.0

INTRODUCTION
THE NEED FOR ASP SO WHAT IS ASP ? W HAT CAN YOU DO WITH ACTIVE SERVER PAGES? W HAT DO SERVER-SIDE SCRIPTS LOOK LIKE? W HAT YOU NEED TO RUN ASP
INTERNET INFORMATION SERVICES PERSONAL W EB SERVERBEFORE YOU BEGIN … STEPS FOR INSTALLATION CREATING VIRTUAL DIRECTORIES ACCESSING YOUR WEBPAGE W HAT IS LOCALHOST?

7
7 7 8 8 8
8 9

9
9 9 9 10

HELLO, WORLD (AND MORE) !
ANOTHER WAY … DISPLAYING THE DATE … … AND MORE

11
11 12 12

VARIABLES AND CONSTRUCTS
DIM ‘EM FIRST THE BIG IF FOR-NEXT LOOPS FOR EACH OBJECT IN COLLECTION ... W HILE ... WEND SELECT CASE: COMPLEX CONDITIONS &CONNECTIVES:
AND, OR AND NOT

14
14 15 17 19 19 20 20
20

SUBROUTINES, FUNCTIONS AND INCLUDES
SUBROUTINES FUNCTIONS INCLUDES

21
21 21 22

THE OBJECT MODEL
THE REQUEST OBJECT
SYNTAX COLLECTIONS METHODS NOTE REQUEST.SERVERVARIABLES THE RESPONSE OBJECT SYNTAX COLLECTIONS PROPERTIES METHODS THE SERVER OBJECT SYNTAX PROPERTIES METHODS THE SESSION OBJECT SYNTAX COLLECTIONS PROPERTIES METHODSEVENTS THE APPLICATION OBJECT SYNTAX COLLECTIONS EVENTS

24
24
25 25 25 25

26 27
27 27 27 28

29
29 29 29

29
29 30 30 30 30

30
31 31 31

HANDLING USER INPUT : FORMS & QUERYSTRINGS

32
3

ACTIVE SERVER PAGES 3.0

THE REQUEST.FORM COLLECTION THE REQUEST.QUERYSTRING COLLECTION GET AND POST
W HEN TO USE GET? W HEN TO USE POST?

32 33 34
34 34

DATA MANIPULATION USINGASP
DISPLAYING DATA FROM A TABLE
RETRIEVING DATA MOVING ON TO COMPLEX QUERIES INSERTING DATA INTO A TABLE UPDATING RECORDS DELETING RECORDS MORE ...

35
35
35 38

38 40 40 41

VBSCRIPT REFERENCE
STATEMENTS AND KEYWORDS OPERATORS VBSCRIPT FUNCTIONS
TYPE CHECKING FUNCTIONS VALUE CONSTANT DATA TYPE TYPECASTING FUNCTIONS FORMATTING FUNCTIONS MATH FUNCTIONS DATE FUNCTIONS DATE CONSTANTSDAY OF THE W EEK CONSTANTS STRING FUNCTIONS OTHER FUNCTIONS CONTROL STRUCTURES

42
42 42 43
43 43 43 43 44 45 45 46 46 47 47 49 49

SQL REFERENCE
THE SELECT STATEMENT INNER AND OUTER JOIN STATEMENTS CALCULATED VALUES AND THE GROUP BY CLAUSE THE INSERT STATEMENT THE UPDATE STATEMENT THE DELETE STATEMENT

53
53 54 55 55 56 57

ACTIVEX DATA OBJECTS (ADO) REFERENCE
THE CONNECTION OBJECT...