O'Reilly logo

Dreamweaver CS6 Bible by Joseph W. Lowery

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 18

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required