MACROMEDIA DREAMWEAVER MX 2004-DREAMWEAVER API, Reference

Page: 97 / 486

Database access functions 97
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)
The following values return:
columnArray[0] = "EmpID", columnArray[1] = "LastName",¬
columnArray[2] ="startDate", columnArray[3] = "salary"
MMDB.getSPParameters()
Availability
Dreamweaver MX.
Description
This function returns an array of parameter objects for a named procedure.
Arguments
connName
,
procName
•
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
procName
argument is the name of the procedure.
000_DW_API_Print.book Page 97 Wednesday, August 20, 2003 9:14 AM