User Guide

Database access functions 101
Example
The following code displays the results of the executed SQL statement:
MMDB.showResultset("EmpDB","Select EmpName,EmpFirstName,Age ¬
from Employees")
MMDB.showSPResultset()
Availability
Dreamweaver UltraDev 1.
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)
000_DW_API_Print.book Page 101 Wednesday, August 20, 2003 9:14 AM