Table of Contents Preface Chapter 1 First Contact with ASP 1
1.1 Introduction to ASP 1
1.1.1 What is ASP 1
1.1.2 Functions of ASP 1
1.1.3 Scope of use 2
1.2 Development of ASP 2
1.2.1 Establishment of environment 2
1.2.2 Development Tools 3
1.2.3 Programming 3
1.2.4 Global.asa file 5
1.3 ASP security 6
1.3.1 Windows NT and IIS 6
1.3.2 IIS security vulnerabilities 7
Chapter 2 ASP Embedded Objects 9
2.1 Response and Request objects 10
2.1.1 Properties of Response object 25
2.1.2 Properties of Request object 25
2.1.3 Methods of Request object 26
2.2 Application object 26
2.2.1 Collection 27
2.2.2 Method 28
2.2.3 Event 29
2.3 Session object 30
2.3.1 Collection 31
2.3.2 Properties 32
2.3.3 Method 33
2.3.4 Event 33
2.4 Sever object 35
2.4.1 Properties 35
2.4.2 Method 36
2.5 Application examples 38
Chapter 3 ASP Components 47
3.1 Advertising rotation component 47
3.1.1 Required documents 47
3.1.2 Properties 49
3.1.3 Method 49
3.2 Browser compatible components 49
3.3 File operation components 51
Chapter 4 Introduction to Database 55
4.1 MS SQL Server 7.0 55
4.1.1 Introduction 55
4.1.2 Database operations 56
4.2 Structured Query Language 65
4.2.1 Introduction 65
4.2.2 Functional features of SQL language 65
4.2.3 T-SQL 66
4.2.4 In-depth understanding of T-SQL structured query language 76
4.2.5 SQL language application skills 83
Chapter 5 Using Databases 89
5.1 Introduction to ADO 89
5.1.1 Connecting to data sources 89
5.1.2 Operating data sources 90
5.1.3 Obtaining data 90
5.1.4 Usage data 91
5.1.5 Detecting errors 91
5.2 Connection object 92
5.2.1 Properties 92
5.2.2 Method 93
5.3 Error object 95
5.4 Recordset object 95
5.4.1 Method 95
5.4.2 Properties 97
5.5 Command Object 98
5.5.1 Collection 100
5.5.2 Method 100
5.5.3 Properties 101
5.5.4 Stored procedures 103
5.6 ASP and database connection 105
5.6.1 Using ODBC to connect to the database 106
5.6.2 Not using ODBC to connect to the database 112
Chapter 6 Database Data Operation 114
Chapter 7 ASP Debugging and Efficiency 123
7.1 Debugging ASP applications 123
7.2 ASP efficiency 125
7.2.1 ASP script size 125
7.2.2 Code writing 125
7.2.3 Session status 126
7.2.4 Database 127
7.2.5 Creating objects 127
7.2.6 Arrays 128
Chapter 8 Customizing Components with ASP 129
Chapter 9 Detailed explanation of ASP counter design 132
9.1 Create graphic files 132
9.2 Creating a database 132
9.3 Writing code 132
Chapter 10 Displaying Online Statistics with ASP 135
10.1 Creating a database 135
10.2 Creating graphics files 135
10.3 Writing code 135
Chapter 11 Using ASP to implement electronic shopping 140
11.1 Creating a database 140
11.2 Writing code 140
Chapter 12 Using ASP to implement web page BBS 149
12.1 Creating a database 149
12.2 Writing code 150
Chapter 13 Writing MIS with ASP 172
Appendix A HTML Reference 180
Appendix B VBScript Reference 195
