jo's Tech Pot

1.05.2006

Macromedia ColdFusion - Displaying Database Data on a Web Page

Source

The strength of Macromedia ColdFusion lies in its ability to connect to many types of data sources and display that information dynamically on web pages. One strong application is exemplified by selling products on a website. If you were to use static web pages instead of ColdFusion, you'd have to create a new web page for every product you'd like to sell. Usually, that data already resides in a data source of some kind. Using CFML, you can query product information in your database quickly and easily, and dynamically create a detailed product web page based on your customer's request.


ColdFusion can connect to a variety of data sources, including the following, among others:

  • Relational database
  • Text file
  • Microsoft Excel spreadsheet


The ColdFusion Administrator has a menu grouping for Data & Services on the main, left menu. There are several types of connections you can make to a relational database: JDBC, ODBC, OLE DB, and Native. This article focuses on connecting to JDBC databases.

Because ColdFusion runs on top of a Java server, the connections to data sources are created using JDBC—an industry standard for connecting to many different data sources from Java-based applications. Using a JDBC connection, ColdFusion can send SQL statements to the database, and receive result sets from it.

0 Comments:

Post a Comment

<< Home