<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}	edit 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}	edit 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}	edit Corresponds to the actual value that Lucee passes to the stored procedure.
sqlType _{string, optional}	edit The SQL type that the parameter (any type) will be bound to.
maxLength _{number, optional}	edit Maximum length of the parameter.
scale _{number, optional}	edit Number of decimal places of the parameter.
null _{boolean, optional}	edit 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}	edit This attribute has been deprecated and is non-functional. * deprecated *
CFSQLType _{string, optional}	edit This attribute has been deprecated, use instead the attribute "sqltype" that has exact the same functionality. * deprecated *

Examples

edit

There are currently no examples for this tag.

<cfprocparam>

Unimplemented Attribute(s)

Examples

See also