cfstoredproc

Executes a stored procedure in a server database. It
specifies database connection information and identifies
the stored procedure.

 <cfstoredproc procedure="">

 cfstoredproc(procedure="");

cfstoredproc Attribute Reference

procedure
Required

Name of stored procedure on database server.

datasource

Name of data source that points to database that contains
stored procedure.

username

Overrides username in data source setup.

password

Overrides password in data source setup.

blockfactor

Maximum number of rows to get at a time from server.
Range is 1 to 100.

debug
Default: NO

Yes: Lists debug information on each statement
No: does not

returncode
Default: NO

Yes: Tag populates cfstoredproc.statusCode with status
code returned by stored procedure.
No: does not

result

Specifies a name for the structure in which cfstoredproc
returns the statusCode and ExecutionTime variables. If
set, this value replaces cfstoredproc as the prefix to
use when accessing those variables.

Fork me on GitHub