Looping in Coldfusion - Coldfusion tutorial

Category: Coldfusion tutorials > Development - Difficulty:

As a newbie, you can expect to hear comments about "newbie tags". You may hear "Oh, I'd never use CFINSERT or CFUPDATE, I only use SQL within CFQUERY". If you follow a discussion on this you won't see any strong technical cases against them and when I've pushed the discussion, it ends up being admitted that problems haven't been seen since 4.5 but "SQL is much more flexible and powerful".

This technical note describes ColdFusion expressions -- language constructs that allow you to create sophisticated applications.

Writing maintainable code

ColdFusion makes it easy to select data out of a database and display it on a page. As soon as you feel good about your success in crossing the divide from static to dynamic, someone will say "That's nice, can you group the list by author?". Whether you are asked to group things by author, make, brand, year or whatever, ColdFusion has you covered with its grouping capabilities.

A simple coldfusion tutorial which explains how to query a database using coldfusion. Querying a database in coldfusion is similar to other programming languages. The query is usually placed at the top of the page, or before where it is used. The query is as below with an opening tag with the name of the query and the datasource that you are querying. Between the opening and closing tags you insert your sql code.