Establishing Connections and Recordsets
In This Chapter
- Examining the structured world of databases
- Dreamweaver Technique: Setting Up a Dynamic Site
- Making a basic connection
- Dreamweaver Technique: Declaring an ODBC Data Source
- Dreamweaver Technique: Creating an ASP Connection
- Dreamweaver Technique: Defining a ColdFusion Connection
- Dreamweaver Technique: Setting Up a PHP Connection
- Crafting custom connection strings
- Pinpointing data with recordsets
- Dreamweaver Technique: Defining a Recordset
- Writing SQL queries
Although Dreamweaver can be used to build any sort of web application, one of its biggest strengths is its capability to present and manage dynamically accessed data. In other words, many designers use Dreamweaver to display and alter information from a database on the web. But to handle that information, you must first establish a connection between the web page and the desired data source and then you must define a selection of records from that data source.
Dreamweaver is adept at handling both of these pieces. You can connect to virtually any data source—databases, spreadsheets, and even standard text files—in a number of different ways. Dreamweaver offers a variety of connection types, ranging from the simplest with the highest overhead, DSN (Data Source Name), to the more complex, but most efficient, OLE DB. This chapter explains how the connections are made in Dreamweaver and why some are more robust than others.
After you have established a connection ...