Beginning ASP Databases

* Offers an entry point to one of the most crucial aspects of Microsoft-oriented Web development--database integration with Active Server Pages

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.