<cfprocparam>

Specifies parameter information, including type, name, value, and length. The cfprocparam tag is nested within a cfstoredproc tag.

Usage

<cfprocparam
    [maxlength=number]
    [variable=string]
    [scale=number]
    [null=boolean]
    [cfsqltype=string]
    [type=string]
    [dbvarname=string]
    [value=any]
    [sqltype=string]
>

This tag cannot have a body.

This tag is also supported within cfscript

Attributes

Attribute Description
maxlength
(number, optional)

Maximum length of the parameter.

variable
(string, optional)

The variable name that you use to reference the value that the output parameter represents after the call is made to the stored procedure.

scale
(number, optional)

Number of decimal places of the parameter.

null
(boolean, optional)

Indicates whether the parameter is passed as a null. If you specify Yes, the tag ignores the value attribute.

cfsqltype
(string, optional)

This attribute has been deprecated, use instead the attribute "sqltype" that has exact the same functionality.

type
(string, optional)

Indicates whether the passed variable is an input, output or input/output variable. Default is IN. The value IN passes the parameter by value. Values OUT and INOUT pass parameters as bound variables.

dbvarname
(string, optional)

This attribute has been deprecated and is non-functional.

value
(any, optional)

Corresponds to the actual value that Lucee passes to the stored procedure.

sqltype
(string, optional)

The SQL type that the parameter (any type) will be bound to.

Examples

There are currently no examples for this tag.