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 |