Programming ColdFusion MX, 2nd Edition

Name

cfprocresult

Synopsis

<cfstoredproc>
  [<cfprocparam>]
  ...
  [<cfprocresult>]
  ...
</cfstoredproc>

Specifies the name for a result set returned by the cfstoredproc tag. This allows other ColdFusion tags to reference the result set. One or more cfprocresult tags may be nested within the cfstoredproc tag.

Attributes

name=" query_name "

A name for the query result set returned by the stored procedure. Required.

maxrows=" row_number "

The maximum number of rows to return with the result set. Optional. By default, maxrows is set to -1, resulting in all rows returned.

resultset=" integer "

The result set to use if the stored procedure returns more than one result set. You must have one cfprocresult tag for each result set returned by the stored procedure. Optional. The default value is 1.