Cover image for Beginning ASP databases
Title:
Beginning ASP databases
Author:
Kauffman, John.
Personal Author:
Publication Information:
Chicago, Ill : Wrox Press, [1999]

©1999
Physical Description:
xix, 825 pages : illustrations ; 24 cm
General Note:
Includes index.
Language:
English
ISBN:
9781861002723
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Central Library TK5105.8885.A26 K38 1999 Adult Non-Fiction Central Closed Stacks
Searching...

On Order

Summary

Summary

Microsoft created Active Server Pages (ASP) to sew together a group of technologies for creating modern web sites, which can intelligently interact with the user at the front end and with servers and datastores at the back end. Among these technologies is ActiveX Data Objects (ADO), which allows easy, powerful and robust control of technologies that access datastores. This book explains the theory and practice of using ADO with ASP by presenting numerous examples, exercises, lists of common errors and quizzes. The emphasis is on the authors' proven teaching techniques and the presentation of the most commonly used features of ADO in ASP.


Table of Contents

Introductionp. 1
Chapter 1 Why Use ASP and ADO to Put Your Database on the Web?p. 11
Databases in the Modern Worldp. 13
What ASP and ADO Can Dop. 20
Why use Server-Side Solutions?p. 26
Take Home Points: A Summary Of Terminologyp. 31
Chapter 2 Setting Up ASP and ADOp. 35
Overview of Components and Optionsp. 36
Server Support for ASPp. 37
Installing IIS on NT Serverp. 37
Installing IIS and ASP on Windows 2000 (Workstation or Server)p. 43
Installing PWS on Win 9xp. 46
Installing ADO on IIS/NT/Win 2000 or Win9x/PWSp. 61
Setting up DSNsp. 64
Is it all working?p. 74
Chapter 3 Simple Recordsets - Reading Datap. 81
Preparing to use Simple Recordsetsp. 81
Syntax for Simple Recordsetsp. 82
Which Record?p. 89
Building Tables with Datap. 91
Reading All of the Records (with EOF)p. 95
A Trap With Recordsets and Tablesp. 99
A Note on Moving in Recordsetsp. 100
Chapter 4 Basic SQL for ADO Recordsetsp. 109
Introduction to SQLp. 109
SQL Syntaxp. 110
SELECT Statementsp. 114
ORDER BY Clausep. 117
WHERE Clausep. 119
Building SQL Statements with a Query Gridp. 125
JOIN Queries - A Marriage of Tablesp. 130
Incorporating Data from HTML Forms into SQL Statementsp. 132
Troubleshooting SQL Statementsp. 142
Chapter 5 More Uses for Simple Recordsetsp. 159
Introductionp. 159
Filling a List Boxp. 160
Fields Collectionp. 164
Making a Table Procedurep. 167
Writing Tables With the GetString Methodp. 171
Common Errors when Using GetStringp. 172
Chapter 6 Connectionsp. 187
Introductionp. 187
Why Use Connection Objects?p. 187
Implicit and Explicit Connectionsp. 188
Making Connectionsp. 189
Alternative Types of Connectionsp. 195
Connection Poolingp. 205
Viewing and Changing Connection Propertiesp. 206
Elucidating Schemap. 207
Chapter 7 Behind the Scenes of ADOp. 223
Introductionp. 223
The Componentsp. 223
The Processp. 229
Troubleshooting ASP/ADOp. 231
Chapter 8 Recordset Parametersp. 255
Parameter Overviewp. 255
Errorsp. 256
Source Parameterp. 257
The ActiveConnection Parameterp. 270
The CursorType Parameterp. 270
The LockType Parameterp. 275
Options Parameterp. 283
Chapter 9 RecordSet Methods and Propertiesp. 293
Introductionp. 293
Supported Methodsp. 294
Findp. 299
Filter Propertyp. 304
AddNewp. 304
Update and Batch Updatep. 313
UpdateBatchp. 318
Deletep. 320
Editing Data in Recordsp. 328
Navigation Through Recordsp. 328
Chapter 10 SQL Statements To Modify Datap. 341
Distinction Between Adding and Updatingp. 341
Where Does The Data Come From?p. 342
Inserting A Recordp. 343
Updating A Recordp. 356
Deleting A Recordp. 372
Chapter 11 Databases and Cookiesp. 403
Review of Cookiesp. 403
Syntax to Work with Cookies in Simple ASP (no ADO)p. 408
Using Cookies with ADO and a Databasep. 414
Reading Cookies for Use in Database Look-Upp. 415
Resetting a Cookiep. 419
Chapter 12 The Errors Collectionp. 435
Introductionp. 436
How to Get Error Informationp. 451
Using Error Information in Developmentp. 453
Using Error Information in Productionp. 462
Common Errorsp. 467
ASP Helpp. 473
Chapter 13 Command Objectp. 485
Command Object Overviewp. 486
Command Object Structurep. 486
When You Must Use a Command Objectp. 489
When it is Useful to Use a Command Objectp. 502
Parametersp. 506
Stuffing Techniquesp. 519
Chapter 14 Stored Procedures and Passing Parametersp. 541
Benefitsp. 541
Applicationp. 543
Trapsp. 545
Passing Values to a Stored Procedurep. 546
Retrieving Values From a Stored Procedurep. 575
Chapter 15 Irregular Datap. 597
Introductionp. 597
How Binary Data is Storedp. 598
Working With Binary Datap. 599
Uploading BLOB Datap. 611
Working With Access Memo and SQL Server Text Fieldsp. 617
Chapter 16 ADO Tips and Tricksp. 625
SQL Data Shortcomingsp. 625
Retrieving the Number of Recordsp. 633
Empty HTML Table Cellsp. 635
Multiple Recordsetsp. 637
Refreshing Command Objectsp. 643
Additional Booksp. 646
Chapter 17 Performance Testing and Performance Improvementsp. 651
Introductionp. 651
Server Issuesp. 651
Database Issuesp. 655
Coding Issuesp. 657
Testing ADO Performance With ASPp. 662
The Sailors Case Studyp. 681
The Sailors Web Sitep. 682
The Include Filesp. 683
Global.asap. 688
Logging On and Registrationp. 689
Web Site User Optionsp. 714
Interesting Observationsp. 738
Some Things To Tryp. 738
Appendix A Structure of Sailors.mdbp. 741
Introduction and Objectivep. 741
Vocabulary and Business Rulesp. 741
Where to Downloadp. 742
Structure and Relationships of Tablesp. 742
Overview of Queriesp. 742
Structure of Tablesp. 743
Structure of Queriesp. 745
Appendix B Structure of Clothier.mdbp. 749
Introduction and Objectivep. 749
Vocabulary and Business Rulesp. 749
Where to Downloadp. 749
Structure of Tables and Queriesp. 750
Table Datap. 750
Appendix C Profile.mdb Database Schemap. 753
Tablesp. 753
Stored Queriesp. 756
Appendix D Creating a Sailors Database in SQL Serverp. 759
Creating the Sailors Databasep. 759
Creating the Data Source Namep. 759
Exporting the Tablesp. 760
Appendix E Active Server Pages Object Modelp. 765
The Request Objectp. 765
The Response Objectp. 766
The Application Objectp. 767
The Session Objectp. 768
The Server Objectp. 768
The ObjectContext Objectp. 769
Appendix F Microsoft ActiveX Data Objects 2.0 Library Referencep. 771
Objectsp. 771
Command Objectp. 772
Connection Objectp. 773
Error Objectp. 775
Errors Collectionp. 776
Field Objectp. 776
Fields Collectionp. 777
Parameter Objectp. 778
Parameters Collectionp. 779
Propertiesp. 779
Property Objectp. 780
Recordset Objectp. 780
Method Calls Quick Referencep. 785
Appendix G VBScript Referencep. 789
Array Handlingp. 789
Assignmentsp. 790
Constantsp. 790
Control Flowp. 794
Functionsp. 795
Variable Declarationsp. 800
Error Handlingp. 800
Input/Outputp. 801
Proceduresp. 803
Other Keywordsp. 803
Visual Basic Run-time Error Codesp. 803
Indexp. 809

Google Preview