<CFPROCPARAM TYPE="IN/OUT/INOUT"
VARIABLE="variable name"
DBVARNAME="DB variable name"
VALUE="parameter value"
CFSQLTYPE="parameter datatype"
MAXLENGTH="length"
SCALE="decimal places"
NULL="yes/no">
TYPE
Optional. Indicates whether the passed variable is an input, output or input/output variable. Default is IN.
VARIABLE
Required for OUT and INOUT parameters. This is the ColdFusion variable name that you use to reference the value that the output parameter represents after the call is made to the stored procedure.
DBVARNAME
Required if named notation is desired. This is the parameter name. This corresponds to the name of the parameter in the stored procedure.
VALUE
Required for IN and INOUT parameters. This corresponds to the actual value that ColdFusion passes to the stored procedure.
CFSQLTYPE
Required. This is the SQL type that the parameter (any type) will be bound to. The CFSQLTypes are as follows:
CF_SQL_BIGINT
|
CF_SQL_IDSTAMP
|
CF_SQL_REAL
|
CF_SQL_CHAR
|
CF_SQL_INTEGER
|
CF_SQL_SMALLINT
|
CF_SQL_DATE
|
CF_SQL_LONGVARCHAR
|
CF_SQL_TIME
|
CF_SQL_DECIMAL
|
CF_SQL_MONEY
|
CF_SQL_TIMESTAMP
|
CF_SQL_DOUBLE
|
CF_SQL_MONEY4
|
CF_SQL_TINYINT
|
CF_SQL_FLOAT
|
CF_SQL_NUMERIC
|
CF_SQL_VARCHAR
|
MAXLENGTH
Optional. Maximum length of the parameter.
SCALE
Optional. Number of decimal places of the parameter.
NULL
Optional. Specify Yes or No. Indicates whether the parameter is passed as a NULL. If you specify Yes, the tag ignores the VALUE attribute.
|