Download CD Content
The purpose of this chapter is to continue the study of using a database with middleware programming by demonstrating deleting and updating records in the database, and complex queries involving more than one table.
The previous chapter showed the benefits of middleware by demonstrating how to build a Web application giving visitors to a Web site the ability to add information to a database and to display the current database contents. This capability changes the Web from a static to a dynamic medium. However, this is only the start of what is possible.
The benefits of databases as opposed to simple files, also known as flat files, are demonstrated when the application requires operations other than the insertion of records and display of all records. This chapter will build on the prior ones and show you how to delete records, update information in records, and request customized views of the database contents.