Lesson 14. Connecting to Data Sources
In Lesson 13, Dynamic, Data-Driven Sites , you got your Macromedia ColdFusion site up and running. You also created a simple ColdFusion application that displayed a variable passed through a Web form from a different page. The real power of a server model such as ColdFusion is its ability to interact with data sources such as text files, XML documents, andabove alldatabases. With those data sources, ColdFusion (or ASP, PHP, or JSP) can insert, edit, delete, and/or extract a particular set of data, and output that data as if it were standar217. This interactivity with a data source enables you to create password-protected pages, surveys, testing environments, message boards, dynamic press release applications, and so forth. To achieve any of this functionality, you'll need to define a data source so ColdFusion knows how to find and communicate with the data. After ColdFusion knows how to access the data sourcein this case, a Microsoft Access databaseyou'll create a page that displays data from the database live, the moment a user requests it. The data displayed in the second row of the table is pulled dynamically from the database.