Adobe Dreamweaver API Reference CS5 - Manual (Page 82)

77 DREAMWEAVER API REFERENCE
The database API
Last updated 8/27/2013
Description
This function displays a dialog box that contains the results of executing 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.
Arguments
connName, procName, 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 to execute.
• The paramValuesArrayargument is an array that contains a list of design-time parameter test values. Specify the
parameter values in the order in which the stored procedure expects them. You can use the
MMDB.getSPParamsAsString() function to get the parameters of the stored procedure.
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 paramValueArray = new Array("2/1/2000", "50000")
MMDB.showSPResultset("EmpDB", "getNewEmployeesMakingAtLeast", ¬
paramValueArray)
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.