cfstoredproc

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

 <cfstoredproc procedure="">

 cfstoredproc(procedure="");

Attribute Reference for the cfstoredproc tag

procedure

Required: Yes
Name of stored procedure on database server.

datasource

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

username

Required: No
Overrides username in data source setup.

password

Required: No
Overrides password in data source setup.

blockfactor

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

debug

Required: No
Default: NO
Yes: Lists debug information on each statement
No: does not

returncode

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

result

Required: No
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