CFPROCRESULT  
 
 

The CFPROCRESULT tag is nested within a CFSTOREDPROC tag. This tag's NAME parameter specifies a result set name that other ColdFusion tags, such as CFOUTPUT and CFTABLE, use to access the result set. It also allows you to optionally identify which of the stored procedure's result sets to return.

 
 
  Syntax  
 
<CFPROCRESULT NAME="query_name"
    RESULTSET="1-n" 
    MAXROWS="maxrows">

NAME

Required. Name for the query result set.

RESULTSET

Optional. Specify this parameter to identify the desired result set if the stored procedure returns multiple result sets. Default is 1.

MAXROWS

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

 
 
  Usage  
 

Specify one or more CFPROCRESULT tags to enable access to data returned by the stored procedure.

RESULTSET must be unique within the scope of the CFSTOREDPROC tag. If you specify the same result set twice, the second occurrence overwrites the first.





 
 
BackUp LevelNext
 
 

allaire     AllaireDoc@allaire.com
    Copyright © 1998, Allaire Corporation. All rights reserved.