User Guide

Database access functions 93
MMDB.getSPColumnListNamedParams()
Availability
Dreamweaver UltraDev 1.
Description
This function gets a list of result set columns that are generated by a call to the specified
stored procedure.
Arguments
connName, statement, 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 statement 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. 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 that 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 can 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)
000_DW_API_Print.book Page 93 Wednesday, July 20, 2005 11:58 AM