<cfprocparam>

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

The cfprocparam tag is nested within a <cfstoredproc> tag.

This tag cannot have a body.

This tag is also supported within <cfscript>


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

Attribute	Description
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.
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.
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.
maxlength _{number, optional}	Maximum length of the parameter.
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.

Unimplemented Attribute(s)

Attribute	Description
dbvarname _{string, optional}	This attribute has been deprecated and is non-functional. * deprecated *
cfsqltype _{string, optional}	This attribute has been deprecated, use instead the attribute "sqltype" that has exact the same functionality. * deprecated *

Examples

There are currently no examples for this tag.

<cfprocparam>

Unimplemented Attribute(s)

Examples

See also