User Guide

352 Chapter 2: ColdFusion Tags
Attributes
Attribute Req/Opt Default Description
value Required Value that ColdFusion passes to the right of the
comparison operator in a
where clause.
If
CFSQLType is a date or time option, ensure that the date
value uses your DBMS-specific date format. Use the
CreateODBCDateTime or DateFormat and TimeFormat
functions to format the date value.
CFSQLType Optional CF_SQL_
CHAR
SQL type that parameter (any type) is bound to:
• CF_SQL_BIGINT
• CF_SQL_BIT
• CF_SQL_CHAR
• CF_SQL_BLOB
• CF_SQL_CLOB
• CF_SQL_DATE
• CF_SQL_DECIMAL
• CF_SQL_DOUBLE
• CF_SQL_FLOAT
• CF_SQL_IDSTAMP
• CF_SQL_INTEGER
• CF_SQL_LONGVARCHAR
• CF_SQL_MONEY
• CF_SQL_MONEY4
• CF_SQL_NUMERIC
• CF_SQL_REAL
• CF_SQL_REFCURSOR
• CF_SQL_SMALLINT
• CF_SQL_TIME
• CF_SQL_TIMESTAMP
• CF_SQL_TINYINT
• CF_SQL_VARCHAR
maxLength Optional Length of
string in
value
attribute
Maximum length of parameter. Ensures that the length
check is done by ColdFusion before the string is sent to the
DBMS, thereby helping to prevent the submission of
malicious strings.
scale Optional 0 Number of decimal places in parameter. Applies to
CF_SQL_NUMERIC and CF_SQL_DECIMAL.
null Optional No Whether parameter is passed as a null value:
• Yes: tag ignores the
value attribute.
• No
list Optional No • Yes: the
value attribute value is a delimited list.
• No
separator Required, if
you specify a
list in
value
attribute
, (comma) Character that separates values in list, in
value attribute.