
Contents > Developing ColdFusion MX Applications > Accessing and Retrieving Data > Working with dynamic data

Working with dynamic data

A web application page is different from a static web page because it can publish data dynamically. This can involve querying databases, connecting to LDAP or mail servers, and leveraging COM, DCOM, CORBA, or Java objects to retrieve, update, insert, and delete data at runtime--as your users interact with pages in their browsers.

For ColdFusion developers, the term data source can refer to a number of different types of structured content accessible locally or across a network. You can query web sites, LDAP servers, POP mail servers, and documents in a variety of formats. Most commonly though, a database drives your applications, and for this discussion a data source means the entry point from ColdFusion to a database.

In this chapter, you build a query to retrieve data from the CompanyInfo data source. In Windows, this data source connects to a Microsoft Access database (company.mdb). In UNIX, this data source connects to a dBASE database. In subsequent chapters in this book, you insert and update data in this database.

To query a database, you must use:

ColdFusion data sources
The cfquery tag
SQL commands


Contents > Developing ColdFusion MX Applications > Accessing and Retrieving Data > Working with dynamic data

Version 6.1

Comments are no longer accepted for ColdFusion MX 6.1. ColdFusion 8 is the current version.

Send me an e-mail when comments are added to this page | Comment Report

Current page: http://livedocs.adobe.com/coldfusion/6.1/htmldocs/querydb2.htm