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
Summary of Contents for DREAMWEAVER MX 2004
Page 1: ...Dreamweaver API Reference...
Page 24: ...24 Contents...
Page 32: ......
Page 70: ...70 Chapter 5 Fireworks Integration...
Page 76: ...76 Chapter 6 Flash Integration...
Page 116: ...116 Chapter 9 The JavaBeans API...
Page 140: ......
Page 152: ...152 Chapter 11 Application...
Page 218: ...218 Chapter 12 Workspace...
Page 248: ...248 Chapter 13 Site...
Page 292: ...292 Chapter 14 Document...
Page 378: ...378 Chapter 17 Design...
Page 430: ...430 Chapter 18 Code...
Page 486: ...486 Index...