cfprocparam

Defines stored procedure parameters. This tag is nested within
a cfstoredproc tag.

 <cfprocparam cfsqltype="CF_SQL_BIGINT">

 cfprocparam(cfsqltype="CF_SQL_BIGINT");

cfprocparam Attribute Reference

type
Default: in

in: The parameter is used to send data to the database
system only. Passes the parameter by value.
out: The parameter is used to receive data from the
database system only. Passes the parameter as a bound
variable.
inout: The parameter is used to send and receive data.
Passes the parameter as a bound variable. Values:
  • in
  • out
  • inout

variable

CFML variable name; references the value that the
output parameter has after the stored procedure is called.

value

Value that CFML passes to the stored procedure.

cfsqltype
Required

SQL type to which the parameter (any type) is bound.
CFML supports the following values, where the last
element of the name corresponds to the SQL data type.
Different database systems might support different subsets
of this list. See your DBMS documentation for information
on supported parameter types. Values:
  • 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
Default: 0

Maximum length of a string or character IN or INOUT value
attribute. A maxLength of 0 allows any length. The
maxLength attribute is not required when specifying
type=out.

scale
Default: 0

Number of decimal places in numeric parameter. A scale of 0
allows any number of decimal places.

null
Default: NO

Whether the parameter is passed in as a null value. Not
used with OUT type parameters.

Fork me on GitHub