<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.

This tag cannot have a body.

This tag is also supported within <cfscript>


		<cfprocresult
    name=string
    resultset=number
    maxrows=number
>

Attribute	Description
name _{string, required}	Name for the query result set. _{Alias: variable}
resultset _{number, optional}	Identifies the desired result set if the stored procedure returns multiple result sets. Default is 1.
maxrows _{number, optional}	Specifies the maximum number of rows returned in the result set. The default is to return all rows in the result set.

Attribute

Description

name

_{string, required}

Name for the query result set.

_{Alias:
variable}

resultset

_{number, optional}

Identifies the desired result set if the stored procedure returns multiple result sets.

Default is 1.

maxrows

_{number, optional}

Specifies the maximum number of rows returned in the result set. The default is to return all rows in the result set.

There are currently no examples for this tag.