Railo 4.2 Reference
Choose a tag:

Tag <CFPROCPARAM>

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

Body

Dieses Tag darf keinen Body haben.

Beispiel

	<cfprocparam
		[cfsqltype="string"]
		[dbvarname="string"]
		[maxlength="number"]
		[null="boolean"]
		[scale="number"]
		[sqltype="string"]
		[type="string"]
		[value="any"]
		[variable="string"]>
	
Diese tag kann auch innerhalb von cfscript verwendet werden
	<cfscript>
		procparam
		[cfsqltype="string"]
		[dbvarname="string"]
		[maxlength="number"]
		[null="boolean"]
		[scale="number"]
		[sqltype="string"]
		[type="string"]
		[value="any"]
		[variable="string"];
	</cfscript>

Attribute

Die Attribute für dieses Tag sind fest vorgegeben. Ausser den nachfolgend angegebenen Attributen dürfen keine weiteren verwendet werden.
Name Typ Required Beschreibung
cfsqltype string No This Attribute is deprecated 
dbvarname string No This Attribute is deprecated 
maxlength number No Maximum length of the parameter. 
null boolean No Indicates whether the parameter is passed as a null. If you specify Yes, the tag ignores
the value attribute. 
scale number No Number of decimal places of the parameter. 
sqltype string No The SQL type that the parameter (any type) will be bound to. 
type string No 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. 
value any No Corresponds to the actual value that Railo passes to the stored procedure. 
variable string No The variable name that you use to reference the value that the output parameter
represents after the call is made to the stored procedure.