CFPROCPARAM

The CFPROCPARAM tag is nested within a CFSTOREDPROC tag. You use it to specify parameter information, including type, name, value, and length.

Syntax

<CFPROCPARAM TYPE="IN/OUT/INOUT"
    VARIABLE="variable name"
    DBVARNAME="DB variable name"
    VALUE="parameter value"
    CFSQLTYPE="parameter datatype"
    MAXLENGTH="length"
    SCALE="decimal places"
    NULL="Yes" or "No">
TYPE

Optional. Indicates whether the passed variable is an input, output or input/output variable. Default is IN.

VARIABLE

Required for OUT and INOUT parameters. This is the ColdFusion variable name that you use to reference the value that the output parameter represents after the call is made to the stored procedure.

DBVARNAME

Required if named notation is desired. This is the parameter ...

Get Sams Teach Yourself ColdFusion® in 21 Days now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial