Chapter 6: Manipulating the Database

Chapter 6 - Manipulating the Database
byGareth Downes-Powellet al.
Wrox Press 2003

Overview

Author: Gareth Downes-Powell

• Adding records

• Updating records

• Deleting records

• Designing the pages

In this chapter we will start building our Dreamweaver Hotel Booking System, to allow guests to book a room, and to change and cancel their bookings.

We will look at the main Dreamweaver MX Server Behaviors, to add, update, and delete data in our database tables.

We will be creating Simple and Advanced Recordsets, to retrieve data stored in our database tables, and will learn how to create SQL queries with dynamic parameters, to select specific records.

Finally, we will be looking at using URL parameters, to pass data from page to page, so that we can keep the user records and the booking records tied together.