Specifications

Chapter 27330
• 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. You
can specify if the procedure requires parameters when it executes. If you have provided
parameter names in
paramNameArray, specify the parameter values in the same order as their
corresponding parameter names appear in
paramNameArray. If you did not provide
paramNameArray, specify the values in the order in which the stored procedure expects them.
Returns
An array of strings that represents the list of columns. This function returns an error if the SQL
statement or the connection string is invalid.
Example
The following code could return a list of result set columns that are generated from the executed
stored procedure,
getNewEmployeesMakingAtLeast:
var paramNameArray = new Array("startDate", "salary")
var paramValueArray = new Array("2/1/2000", "50000")
var columnArray = MMDB.getSPColumnListNamedParams("EmpDB", ¬
"getNewEmployeesMakingAtLeast", paramNameArray, paramValueArray)
The following values are returned:
columnArray[0] = "EmpID", columnArray[1] = "LastName",¬
columnArray[2] ="startDate", columnArray[3] = "salary"
MMDB.getSPParameters()
Availability
Dreamweaver MX
Description
Returns an array of parameter objects for a named procedure.
Arguments
connName, procName
• 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 procedure.