cfprocresult

"-->

 <cfprocresult name = "query_name"          resultSet = "1-n"          maxRows = "maxrows"> 

Description

Used with the CFSTOREDPROC tag, this tag enables you to specify which result set from the stored procedure to use within CFOUTPUT and CFTABLE tags.

Attributes

name (Required)

Name for the query result set.

resultSet (Optional)

Default: 1. Name of one result set if the stored procedure returns more than one.

maxRows (Optional)

Default: -1 (All). Maximum number of rows returned in the result set.