It can be used to access to database. It looks surprisingly similar to standard HTML pages. The difference between Coldfusion and HTML is that a single Coldfusion template can serve up tons of information dynamically rather than having to create a separate page for every item. Templates are the key to the whole ColdFusion experience. This code tells ColdFusion which data source you want to access and sets up variables that you'll use further down the page in the actual HTML code.
Templates use the file extension .cfm.
ColdFusion templates can be built by CF Studio. ColdFusion application is a back-end application that runs behind the scenes and is transparent to the Web surfer. With Coldfusion, Web content can be changed or updated Dynamically. In addition, database driven sites give you the ability to present lots and lots of material on the Web, and Coldfusion programmer only need to design a single template file. Coldfusion makes an existing database a short hop to a full-featured Web site.