Beginning ASP Databases

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.

1: Why Use ASP and ADO to Put Your Database on the Web?.- 2: Setting Up ASP and ADO.- 3: Simple Recordsets — Reading Data.- 4: Basic SQL for ADO Recordsets.- 5: More Uses for Simple Recordsets.- 6: Connections.- 7: Behind the Scenes of ADO.- 8: Recordset Parameters.- 9: RecordSet Methods and Properties.- 10: SQL Statements To Modify Data.- 11: Databases and Cookies.- 12: The Errors Collection.- 13: Command Object.- 14: Stored Procedures and Passing Parameters.- 15: Irregular Data.- 16: ADO Tips and Tricks.- 17: Performance Testing and Performance Improvements.- The Sailors Case Study.- Appendix A: Structure of Sailors.mdb.- and Objective.- Vocabulary and Business Rules.- Where to Download.- Structure and Relationships of Tables.- People Table.- Boats.- BoatClass.- Rank.- Clubs.- Overview of Queries.- Structure of Tables.- Structure of Queries.- Appendix B: Structure of Clothier.mdb.- and Objective.- Vocabulary and Business Rules.- Where to Download.- Structure of Tables and Queries.- Items Table.- Vendors Table.- Table Data.- Appendix C: Profile.mdb Database Schema.- Tables.- profile.- BLOBs.- Stored Queries.- deletetest.- inserttest.- paramselecttest.- selecttest.- updatetest.- Appendix D: Creating a Sailors Database in SQL Server.- Creating the Sailors Database.- Creating the Data Source Name.- Exporting the Tables.- Appendix E: Active Server Pages Object Model.- The Request Object.- The Response Object.- The Application Object.- The Session Object.- The Server Object.- The ObjectContext Object.- Appendix F: Microsoft ActiveX Data Objects 2.0 Library Reference.- Objects.- Command Object.- Connection Object.- Error Object.- Errors Collection.- Field Object.- Fields Collection.- Parameter Object.- Parameters Collection.- Properties.- Property Object.- RecordsetObject.- Method Calls Quick Reference.- Command.- Connection.- Errors.- Field.- Fields.- Parameter.- Parameters.- Properties.- Recordset.- Appendix G: VBScript Reference.- Array Handling.- Assignments.- Constants.- Error constant.- System Color constants.- Comparison constants.- Date and Time constants.- Date Format constants.- Message Box Constants.- String constants.- Tristate constants.- VarType constants.- Control Flow.- Functions.- Conversion Functions.- Date/Time Functions.- Math Functions.- Miscellaneous Functions.- Object Management Functions.- Script Engine Identification.- String Functions.- Variable Testing Functions.- Variable Declarations.- Error Handling.- Input/Output.- MsgBox.- InputBox.- Procedures.- Other Keywords.- Visual Basic Run-time Error Codes.

Kevin Spencer started programming in C in the early 1990s and wrote a number of shareware programs for DOS, most of which were door programs for BBSs. In the process, he learned to construct relational databases in C, and later worked with Microsoft Visual FoxPro and Access. As Internet database connectivity technologies began to emerge from Microsoft, he learned them as well. He then started his own business, Site Design by TAKempis, which specializes in Internet database application programming with ASP/ADO. Microsoft awarded him with the "Most Valuable Professional" award in 1997. He has written articles about Microsoft FrontPage and ASP/ADO for several online magazines, including ASP Today.

This book explains, demonstrates and applies techniques that lie at the intersection of the great tools of the Information Age: the databaswe and Internet. By combining these tools you, can create powerful Web pages. In this book, you'll learn how to incorporate database into your ASP applications using ADO, which provides a set of objects through which you can connect to, read from and write to databases.