User Guide

Database access functions 99
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.
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 99 Wednesday, July 20, 2005 11:58 AM