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. The CFPROCRESULT tag must be nested within the CFSTOREDPROC tag.

Attributes

NAME="query_name"

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

RESULTSET="integer"

The result set to use if the stored procedure returns more than one result set. Optional. The default value is 1.

MAXROWS="row_number"

The maximum number of rows to return with the result set. Optional. By default, all rows are returned.

Get Programming ColdFusion now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial