Specifications

Chapter 27334
MMDB.showSPResultset()
Availability
Dreamweaver UltraDev 1
Description
Displays a dialog box that has the results of executing the specified stored procedure. The dialog
box displays a tabular grid where the header shows the column information and data of the result
set that is generated by the executed stored procedure. If the connection string or the stored
procedure is invalid, an error appears. You can use this function to verify the validity of the stored
procedure.
Arguments
connName, procName, paramValuesArray
• connName 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.
• procName is the name of the stored procedure to execute.
• paramValuesArray 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
Nothing. This function returns an error if the SQL statement or the connection string is invalid.
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
Displays a dialog box that has the results of executing the specified stored procedure. The dialog
box displays a tabular grid where the header shows the column information and data of the result
set that is generated by the executed stored procedure. If the connection string or the stored
procedure is invalid, an error appears. You can use this function to verify the validity of the stored
procedure. This function differs from
MMDB.showSPResultset() 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
• connName 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.
• procName is the name of the stored procedure that returns the result set when it executes.