O'Reilly

- - - -

YASD's
Dynamic Earth

DynaEarth
Tech

- - - -

Main Page

TOC

Bonus Section

Chapter 10 - Readme

Chapter 10 Errata Pages

The examples in this chapter were created with Visual Basic 6.0.

You can register and use the compiled ASP components directly, or you can open the projects and re-build the objects before registering. You do not have to re-compile the components if you don't wish to; you can, instead, use regsvr32.exe to register the components and run the tests directly.

All the code, components and forms, to provide full CRUD (Create Read Update Delete) of authors, titles, and publishers is included with downloadable code. The SQL for the examples is in books.sql. Examples have been tested with SQL Server 6.5 and SQL Server 7.0, with ADO 2.0 and ADO 2.1.

Example to Chapter Mapping

The ASP page access.asp is the entry page to the entire system. This page will list all of the authors, publishers, and book titles, and allow you to Add, Delete, or View (and Update) a specific author, publisher, or book title. You must register all three of the DLLs included with this chapter: Authors.dll, Publishers.dll, and Titles.dll, before accessing access.asp.

Example 10-1 and 10-2, Using returned RecordsetComponent is Authors.dll, method is getAuthors2 page is first.asp
Example 10-3 through 10-7, Using a stored procedure and demonstrating different techniques to process dataComponent is Authors.dll, pages are second.asp and authors1.asp
Example 10-8 and 10-9, Updating multiple tables - using datasets for list populationComponent is Authors.dll, pages are titles.asp and addtitle.asp

Additionally, supporting changes are: New component, Publishers.dll, with test page of publishers.asp, and a new function for Titles.dll

Example 10-10, A Simple InsertComponent is Authors.dll, pages are authors.asp and addauthor.asp
Example 10-11 through 10-13,Deletions and referential integrityComponent is Titles.dll, pages are access.asp and deltitle.asp

Example 10-14 through 10-15, before and after comparison updateComponent is Authors.dll, pages are access.asp and vauthors.asp and updtauthor.asp

For more information