MACROMEDIA DREAMWEAVER 8-DREAMWEAVER API Specifications download pdf (Page 335)

The Database API 335

• paramNameArray 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.

• paramValuesArray is an array that contains a list of design-time parameter test values.

Nothing. This function returns an error if the SQL statement or the connection string is invalid.

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)

MACROMEDIA DREAMWEAVER 8-DREAMWEAVER API Specifications Page 335