User Guide

164 Chapter 2: ColdFusion Tags

Using expressions in textColor and bgColor attributes

The

textColor and bgColor attributes accept the following kinds of values:

• A color value literal

• A hex value

• An expression that selects a text color based on the evaluation of a Boolean expression

The syntax for an expression is as follows:

(CX operator string ? true_condition : false_condition)

The symbol meanings are as follows:

• CX: the column that contains the value to test. For the current column, use CX; if n is the

column to evaluate, use

Cn; for example, C2

• operator: One of these operators: EQ (equal), GT (greater than), LT (less than)

• string: Value to compare against. A literal, such as (C2 EQ Johnson ? blue : green); or

numeric:

(C2 LT 0 ? red : black)

• true_condition: Value for textColor if condition evaluates to "true"

• false_condition: Value for textColor if condition evaluates to "false"

If the string in the expression can be interpreted as a number, the comparisons in the expression

are interpreted as numeric. Otherwise, the comparison is a string comparison.

This code shows an expression that displays the grid element in blue if the grid element contains

the string "Pam"; or black, otherwise:

This example displays the text in red if the value in column 1 is greater than four; or black,

otherwise:

values Optional Formats cells in column as drop-down list boxes;

specify items in drop-down list. Example:

values = "arthur, scott, charles, 1-20, mabel"

valuesDisplay Optional Maps elements in values attribute to string to display

in drop-down list. Delimited strings and/or numeric

range(s).

valuesDelimiter Optional , [comma] Delimiter in

values and valuesDisplay attributes.

Attribute Req/Opt Default Description