![MACROMEDIA DREAMWEAVER 8-DREAMWEAVER API Скачать руководство пользователя страница 92](http://html1.mh-extra.com/html/macromedia/dreamweaver-8-dreamweaver-api/dreamweaver-8-dreamweaver-api_reference_3332054092.webp)
92
The Database API
var procName = String(this thisProcedure.procedure);
}
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"
000_DW_API_Print.book Page 92 Wednesday, July 20, 2005 11:58 AM
Содержание DREAMWEAVER 8-DREAMWEAVER API
Страница 1: ...Dreamweaver API Reference...
Страница 16: ......
Страница 28: ...28 The File I O API...
Страница 38: ...38 The HTTP API...
Страница 68: ...68 Flash Integration...
Страница 100: ...100 The Database API...
Страница 116: ...116 The JavaBeans API...
Страница 144: ...144 The Source Control Integration API...
Страница 146: ......
Страница 254: ...254 Workspace...
Страница 298: ...298 Site...
Страница 354: ...354 Document...
Страница 396: ...396 Page Content...
Страница 488: ...488 Design...
Страница 550: ...550 Code...