A Coldfusion Color Picker Custom Tag - Create and use a Coldfusion custom tag - Coldfusion tutorial

Category: Coldfusion tutorials > Development - Difficulty:

CFQUERYPARAM and Oracle databases

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".

A ColdFusion variable is created by assigning a value to it. Most commonly, you create variables by using the CFSet tag. You can also use the CFParam tag and assignment statements in CFScript. Tags that create data objects also create variables.

Structures are everywhere in the ColdFusion world. As of ColdFusion 4.5, form, application, session, server, request, and URL variables are stored in structures. Allaire Spectra makes extensive use of structures and associative arrays.

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.