Macromedia coldfusion 4.5-cfml language reference User Manual

160

CFPROCPARAM

The CFPROCPARAM tag is nested within a 

CFSTOREDPROC

 tag. You use it to specify 

parameter information, including type, name, value, and length.

<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">

Optional. Indicates whether the passed variable is an input, output or input/
output variable. Default is IN.

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.

Required if named notation is desired. This is the parameter name. This 
corresponds to the name of the parameter in the stored procedure.

Required for IN and INOUT parameters. This corresponds to the actual value that 
ColdFusion passes to the stored procedure.

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_SMALLINT

CF_SQL_BIT

CF_SQL_INTEGER

CF_SQL_TIME

CF_SQL_CHAR

CF_SQL_LONGVARCHAR

CF_SQL_TIMESTAMP

CF_SQL_DATE

CF_SQL_MONEY

CF_SQL_TINYINT

CF_SQL_DECIMAL

CF_SQL_MONEY4

CF_SQL_VARCHAR

CF_SQL_DOUBLE

CF_SQL_NUMERIC

CF_SQL_FLOAT

CF_SQL_REAL