Specifications

The Database API 329
MMDB.getSPColumnList()
Availability
Dreamweaver UltraDev 1
Description
Gets a list of result set columns that are generated by a call to the specified stored procedure.
Arguments
connName, statement, paramValuesArray
• 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.
• statement is the name of the stored procedure that returns the result set when it executes.
• paramValuesArray 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
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 paramValueArray = new Array("2/1/2000", "50000")
var columnArray = MMDB.getSPColumnList("EmpDB", ¬
"getNewEmployeesMakingAtLeast", paramValueArray)
The following values are returned:
columnArray[0] = "EmpID", columnArray[1] = "LastName", ¬
columnArray[2] ="startDate", columnArray[3] = "salary"
MMDB.getSPColumnListNamedParams()
Availability
Dreamweaver UltraDev 1
Description
Gets a list of result set columns that are generated by a call to the specified stored procedure.
Arguments
connName, statement, paramNameArray, paramValuesArray
• 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.
• statement is the name of the stored procedure that returns the result set when it executes.