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

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

value string

Value that CFML passes to the stored procedure.

cfsqltype string
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 numeric
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 numeric
Default: 0

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

null boolean
Default: false

Whether the parameter is passed in as a null value. Not
used with OUT type parameters.
Values:
  • true
  • false

Fork me on GitHub