name

Required;

all

Name of the grid column element. If the grid uses a query, this attribute must be the name of the query column that populates the grid column.

bgColor

Optional;

all

Color of background of grid column.

• Options: same as for the textColor attribute.

bold

Optional;

all

As specified by cfgrid

• yes: displays grid control text in bold.
• no

dataAlign

Optional;

applet, Flash

As specified by cfgrid

Column data alignment:

• left
• right
• center

display

Optional;

all

yes

• yes
• no: hides the column.

font

Optional;

all

As specified by cfgrid

Font of data in column.

fontSize

Optional;

all

As specified by cfgrid

Size of text in column.

header

Optional;

all

yes

Text for the column header. Used only if the cfgrid colHeaders attribute is yes. The default value is yes.

headerAlign

Optional;

applet

As specified by cfgrid

Column header text alignment:

• left
• right
• center

headerBold

Optional;

HTML, applet

As specified by cfgrid

• yes: displays header in bold.
• no

headerFont

Optional;

HTML, applet

As specified by cfgrid

Font for the column header.

headerFontSize

Optional;

HTML, applet

As specified by cfgrid

Size of text for the column header, in pixels.

headerItalic

Optional;

HTML, applet

As specified by cfgrid

• yes: displays column header in italic.
• no

headerTextColor

Optional;

HTML, applet

Color of grid control column header text.

• Options: same as for the textColor attribute.

href

Optional;

HTML, applet

URL or query column name that contains a URL to hyperlink each grid column with.

hrefKey

Optional;

HTML, applet

The query column to use for the value appended to the href URL of each column, instead of the column's value.

italic

Optional;

all

As specified by cfgrid

• yes: displays grid control text in italic.
• no

mask

Optional;

Flash

A mask pattern that controls the character pattern that the form displays or allows users to input and sends to ColdFusion.

For columns with the currency type attribute, the mask specifies the currency symbol. ColdFusion automatically inserts the character before the numeric value.

For columns with text or numeric values, mask specifies the format to display or allow users to input, as follows:

• A = [A-Za-z]
• X = [A-Za-z0-9]
• 9 = [0-9]
• ? = Any character
• All other characters = ColdFusion inserts the literal character.

If the column values are dates or timestamps, ColdFusion uses the mask pattern to format the selected date.

For details of the date/time mask format, see date/time formats in mask attribute.

numberFormat

Optional;

Applet

Format for displaying numeric data in the grid. See the preceding table of attributes.

select

Optional;

all

yes

Determines selection behavior if the cfgrid selectmode attribute value is column, edit, or single; ignored for row or browse values.

• yes: users can select the column or select or edit cells in the column, as specified by the selectmode attribute.
• no: users cannot select the column or select or edit cells in the column.

target

Optional;

HTML, Applet

Frame or standard HTML target in which to open link specified in href.

textColor

Optional;

Applet, Flash

Color of grid element text in column as a hexadecimal number or text name.

To enter a hexadecimal value, use the form "##xxxxxx", where x = 0-9 or A-F; use two number signs or none.

Limitations: In HTML format, must specify a valid HTML color. In Applet format, must be one of the following:

• Any color, in hexadecimal format
• Black
• Red
• Blue
• Magenta
• Cyan
• Orange
• Darkgray
• Pink
• Gray
• White
• Lightgray
• Yellow

type

Optional;

all

You can specify the following values in all formats:

• boolean: column displays as check box; if cell is editable, user can change the check mark.
• numeric: user can sort grid data numerically.
• string_noCase: user can sort grid data as case-insensitive text.

You can specify the following value in applet and Flash formats; it does not work in HTML format:

• image: grid displays the image specified by the URL in the column. If you use a relative URL, the image must be in the CFIDE\classes directory or a subdirectory. If the image is larger than the column cell, it is clipped to fit. Flash images must be JPEG files. Applet images can be JPEG or GIF files.

You can specify the following value in applet format; it does not work in Flash or HTML format.

• image: you can use the following built-in ColdFusion image names, in addition to paths to image files, in the column values:

    -  cd

    - computer

    - document

    - element

    - folder

    - floppy

    - fixed

    - remote

You can specify the following value in Flash format; it does not work in applet or HTML format:

• currency: formats the column data as currency, aligning it around the decimal point. If users sort the grid by using this column, it sorts correctly for the currency, Use the mask attribute to specify a currency symbol; the default value is the dollar sign ($).

values

Optional;

HTML, applet

Formats cells in column as drop-down list boxes; specify items in drop-down list, for example:

valuesDelimiter

Optional;

HTML, applet

, (comma)

Delimiter in values and valuesDisplay attributes.

valuesDisplay

Optional;

HTML, applet

Maps elements in the values attribute to string to display in the drop-down list. Delimited strings and/or numeric ranges.

width

Optional;

all

Column head width

Column width, in pixels.

_

(Underscore) Digit placeholder.

9

Digit placeholder.

.

(Period) Location of mandatory decimal point.

0

Located to left or right of mandatory decimal point; pads with zeros.

( )

Puts parentheses around mask if number is less than 0.

+

Puts plus sign before positive numbers, minus sign before negative numbers.

-

Puts space before positive numbers, minus sign before negative numbers.

,

(Comma) Separates every third decimal-place with a comma.

L,C

Left-justify or center-justify number within width of mask column. First character of mask must be L or C. Default: right-justified.

$

Puts dollar sign before formatted number. Must be the first character of mask.

^

(Caret) Separates left from right formatting.

Y

Year. If the number of pattern letters is two, the year is truncated to two digits; otherwise, it appears as four digits. The year can be zero-padded, as the third example shows in the following set of examples:

Examples:

YY = 03

YYYY = 2003

YYYYY = 02003

M

Month in year. The format depends on the following criteria:

• If the number of pattern letters is one, the format is interpreted as numeric in one or two digits.
• If the number of pattern letters is two, the format is interpreted as numeric in two digits.
• If the number of pattern letters is three, the format is interpreted as short text.
• If the number of pattern letters is four, the format is interpreted as full text.

Examples:

M = 7

MM= 07

MMM=Jul

MMMM= July

D

Day in month.

Examples:

D=4

DD=04

DD=10

E

Day in week. The format depends on the following criteria:

• If the number of pattern letters is one, the format is interpreted as numeric in one or two digits.
• If the number of pattern letters is two, the format is interpreted as numeric in two digits.
• If the number of pattern letters is three, the format is interpreted as short text.
• If the number of pattern letters is four, the format is interpreted as full text.

Examples:

E = 1

EE = 01

EEE = Mon

EEEE = Monday

A

AM/PM indicator.

J

Hour in day (0-23).

H

Hour in day (1-24).

K

Hour in am/pm (0-11).

L

Hour in am/pm (1-12).

N

Minute in hour.

Examples:

N = 3

NN = 03

S

Second in minute.

Other text

You can add other text into the pattern string to further format the string. You can use punctuation, numbers, and all lowercase letters. You should avoid uppercase letters because they may be interpreted as pattern letters.

Example:

EEEE, MMM. D, YYYY at H:NN A = Tuesday, Sept. 8, 2003 at 1:26 PM