Working with Database Records

Top  Previous  Next

 

Once you have connected to a database, you then have access to all the tables of records in that database.

 

Dreamweaver has the concept of a "Recordset", while very often a recordset is a database table, it does not have to be a single table.  It can be a query of several tables which contains subsets of fields available from those tables. This section covers topics that will help you create "Queries" which enable you to retrieve the data you need for your datasets from the available tables and fields in your database.

 

The Visual Query Builder

Building a Single Query

Adding Objects to a Query

Selecting Fields for your Query

Joining Tables

Filtering Records

Sorting Data

Eliminating Duplicate Records

View SQL

Viewing Selected Data

Customizing the Query