User Guide

96 Chapter 7: The Database API
MMDB.getSPColumnList()
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, 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 paramValuesArray argument 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 for 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 can 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 return:
columnArray[0] = "EmpID", columnArray[1] = "LastName", ¬
columnArray[2] ="startDate", columnArray[3] = "salary"
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.
000_DW_API_Print.book Page 96 Wednesday, August 20, 2003 9:14 AM