MACROMEDIA COLDFUSION MX 61-CFML, Reference

Page: 287 / 806

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.