Lucee Tag Reference

Tag <CFPROCRESULT>

Specifies a result set name that other tags, such as cfoutput and cftable, use to access the result set. It also lets you optionally identify which of the stored procedure's result sets to return. The cfprocresult tag is nested within a cfstoredproc tag.

Body

This tag can't have a body.

Example

<cfprocresult
	[maxrows=number]
	name=string
	[resultset=number]>
This tag is also supported within cfscript
<cfscript>
	procresult
		[maxrows=number]
		name=string
		[resultset=number];
</cfscript>

Attributes

The attributes for this tag are fixed. Except for the following attributes no other attributes are allowed.
Name Type Required Description
maxrows number No Specifies the maximum number of rows returned in the result set. The default is to return
all rows in the result set. 
name string Yes Name for the query result set. 
resultset number No Identifies the desired result set if the stored procedure returns multiple result sets.
Default is 1.