CFPROCPARAM

no documentation available

Usage

<cfprocparam>

Attributes

Attribute default required summary
TYPE in Whether this variable is used for passing data in, or getting, data out. Valid values: in, out, inout
VALUE The value that this data represents
CFSQLTYPE The type this data should be translated to in the database (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, CF_SQL_BINARY, CF_SQL_VARBINARY, CF_SQL_NCLOB, CF_SQL_NCHAR, CF_SQL_NVARCHAR)
NULL false Flag to determine if this represents a database NULL
LIST false Flag to determine if this represents a list
SEPARATOR , If this is a list, then this is the delimiter for the list
MAXLENGTH , The maximum length this data should be; throws an error if greater than
PADDING The number of characters this data is padded out to
SCALE 0 The decimal precision of this data if it is a number
DBVARNAME The name of the dbvarname that this parameter is for