MACROMEDIA DREAMWEAVER MX 2004, Reference

Page: 102 / 486

102 Chapter 7: The Database API
MMDB.showSPResultsetNamedParams()
Availability
Dreamweaver UltraDev 1.
Description
This function displays a dialog box that contains the result set of the specified stored procedure.
The dialog box displays a tabular grid in which the header provides column information that
describes the result set. If the connection string or the stored procedure is invalid, an error
appears. This function validates the stored procedure. This function differs from the
MMDB.showSPResultset()
function because you can specify the parameter values by name
instead of the order in which the stored procedure expects them.
Arguments
connName, procName, paramNameArray, paramValuesArray
•
The
connName
argument is a connection name that is specified in the Connection Manager.
It identifies the connection string that Dreamweaver should use to make a database connection
to a live data source.
•
The
procName
argument is the name of the stored procedure that returns the result set
when it executes.
•
The
paramNameArray
argument is an array that contains a list of parameter names. You can
use the
MMDB.getSPParamsAsString()
function to get the parameters of the
stored procedure.
•
The
paramValuesArray
argument is an array that contains a list of design-time parameter
test values.
Returns
This function returns an error if the SQL statement or the connection string is invalid; otherwise,
it returns nothing.
Example
The following code displays the results of the executed stored procedure:
var paramNameArray = new Array("startDate", "salary")
var paramValueArray = new Array("2/1/2000", "50000")
MMDB.showSPResultsetNamedParams("EmpDB","getNewEmployees¬
MakingAtLeast", paramNameArray, paramValueArray)
000_DW_API_Print.book Page 102 Wednesday, August 20, 2003 9:14 AM