This book explains, demonstrates, and applies techniques that intersect with two great tools of the information age. The first tool, the database, is relatively old. On the other hand, the second tool, the Internet, is still quite young. And when you pair these tools—voilà! You can create powerful web pages.
With the help of Beginning ASP Databases, you will learn to incorporate databases into your ASP applications using ADO (which provides a set of objects that you can connect to, read from, and write to). You'll gain comfort installing necessary software handling stored procedures. And this book will answer many real-world questions, complete with code for you to copy and paste.
| Introduction | 1 | |
| Ch. 1 | Why Use ASP and ADO to Put Your Database on the Web? | 11 |
| Ch. 2 | Setting Up ASP and ADO | 35 |
| Ch. 3 | Simple Recordsets - Reading Data | 81 |
| Ch. 4 | Basic SQL for ADO Recordsets | 109 |
| Ch. 5 | More Uses for Simple Recordsets | 159 |
| Ch. 6 | Connections | 187 |
| Ch. 7 | Behind the Scenes of ADO | 223 |
| Ch. 8 | Recordset Parameters | 255 |
| Ch. 9 | RecordSet Methods and Properties | 293 |
| Ch. 10 | SQL Statements To Modify Data | 341 |
| Ch. 11 | Databases and Cookies | 403 |
| Ch. 12 | The Errors Collection | 435 |
| Ch. 13 | Command Object | 485 |
| Ch. 14 | Stored Procedures and Passing Parameters | 541 |
| Ch. 15 | Irregular Data | 597 |
| Ch. 16 | ADO Tips and Tricks | 625 |
| Ch. 17 | Performance Testing and Performance Improvements | 651 |
| The Sailors Case Study | 681 | |
| App. A | Structure of Sailors.mdb | 741 |
| App. B | Structure of Clothier.mdb | 749 |
| App. C | Profile.mdb Database Schema | 753 |
| App. D | Creating a Sailors Database in SQL Server | 759 |
| App. E | Active Server Pages Object Model | 765 |
| App. F | Microsoft ActiveX Data Objects 2.0 Library Reference | 771 |
| App. G | VBScript Reference | 789 |
| Index | 809 |
Overview
This book explains, demonstrates, and applies techniques that intersect with two great tools of the information age. The first tool, the database, is relatively old. On the other hand, the second tool, the Internet, is still quite young. And when you pair these tools—voilà! You can create powerful web pages.
With the help of Beginning ASP Databases, you will learn to incorporate databases into your ASP applications using ADO (which provides a set of objects that you can connect ...