A Practical Guide to
By
Manas Tungare
www.manastungare.com
Active Server Pages
Microsoft
3.0
ACTIVE SERVER PAGES 3.0
2
About this guide ...
This practical guide was prepared as a reference for the ASP Workshop
conducted by Manas Tungare at Fr. Conceicao Rodrigues College of
Engineering in October 2000.
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 been made to ensure correctness & reliability of the
information provided, however the author may not be held responsible for any
errors that may have crept in.
ACTIVE SERVER PAGES 3.0
3
INTRODUCTION 6
THE NEED FOR ASP 6
SO WHAT IS ASP ? 6
WHAT CAN YOU DO WITH ACTIVE SERVER PAGES? 7
WHAT DO SERVER-SIDE SCRIPTS LOOK LIKE? 7
WHAT YOU NEED TO RUN ASP 7
INTERNET INFORMATION SERVICES 7
PERSONAL WEB SERVER 8

SYNTAX 26
COLLECTIONS 26
PROPERTIES 26
METHODS 27
THE SERVER OBJECT 28
SYNTAX 28
PROPERTIES 28
METHODS 28
THE SESSION OBJECT 28
SYNTAX 29
COLLECTIONS 29
PROPERTIES 29
METHODS 29
EVENTS 29
THE APPLICATION OBJECT 29
SYNTAX 30
COLLECTIONS 30
EVENTS 30
HANDLING USER INPUT : FORMS & QUERYSTRINGS 31
ACTIVE SERVER PAGES 3.0
4
THE REQUEST.FORM COLLECTION 31
THE REQUEST.QUERYSTRING COLLECTION 32
GET AND POST 33
WHEN TO USE GET? 33
WHEN TO USE POST? 33
DATA MANIPULATION USING ASP 34
DISPLAYING DATA FROM A TABLE 34
RETRIEVING DATA 35
MOVING ON TO COMPLEX QUERIES 38

OPENING A DATABASE CONNECTION 57
THE CONNECTMODEENUM CONSTANTS 58
THE CONNECTIONSTRING 58
THE CONNECTION.EXECUTE METHOD 60
MANAGING TRANSACTIONS WITH A CONNECTION OBJECT 60
THE RECORDSET OBJECT 61
USING THE RECORDSET.OPEN METHOD 61
POSITIONING A RECORDSET OBJECT — THE MOVE METHODS 63
RECORDSET SORTING AND SEARCHING METHODS 64
THE FIELD OBJECT 65
EXTENDING ASP : COM COMPONENTS 66
THE BASICS 66
PROPERTIES 66
METHODS 67
ARGUMENTS 67
COLLECTIONS 68
THE DEFAULT METHOD OR PROPERTY 69
ACTIVE SERVER PAGES 3.0
5
INSTANTIATING AN OBJECT 69
BUILT-IN COM OBJECTS 70
PROGID 70
FURTHER ON ... 70
COPY & PASTE ASP SCRIPTS 71
FEEDBACK PAGE 71
TELL A FRIEND ABOUT THIS SITE 72
FURTHER EXAMPLES 73
THE ASP RESOURCE GUIDE 74
EDITORS 74
TEXTPAD 74