• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Part: 6 Dreamweaver and ColdFusion PROJE... > Connecting to Data Sources

Lesson 15. Connecting to Data Sources

In Lesson 14, “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, and above all, databases. 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 standard HTML. 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 need to define a data source so ColdFusion knows how to find and communicate with the data. Once ColdFusion knows how to access the data source—in this case, a Microsoft Access database—you will 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.


In this lesson, you will:

  • Learn foundational database concepts

  • Create a ColdFusion DSN for your site

  • Build a form that collects biographic information from a user

  • Save the user's form data to a database

  • Build a recordset from a SQL query and display live database data in the browser


This lesson takes approximately 60 minutes to complete.


Starting Files:



Completed Files:




Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint