| by Matthew Pizzi IN THIS CHAPTER In the previous chapters, you learned how you can use Dreamweaver MX to create Web applications, and you looked at the possibility of managing dynamic data. The chapters also laid some groundwork for setting a Web server that is prepared to serve these application pages containing server-side scripts. To build a successful application, as you can probably tell from the previous two chapters, certain parameters must be set up and defined. After having a working application server, you must also have an established connection between the pages you create in Dreamweaver and the database you want to send and retrieve data from. The middleware you want to use determines how you open communication with the database. Dreamweaver MX supports a variety of connections from a standard DSN (Data Source Name) to other more advanced connections, such as OLE DB. After you've established which connection you'll be using, you'll then have the capability to query the different tables in the database through Structured Query Language (SQL), which is covered in greater detail in Chapter 27, "SQL Primer." These queries in Dreamweaver are often called recordsets. | 
