User Guide

cfqueryparam 287
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.
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.