User Guide

Database access functions 95
var tooltiptext = paramObj.datatype;
tooltiptext+=" ";
tooltiptext+=GetDirString(paramObj.directiontype);
}
MMDB.getSPParamsAsString()
Availability
Dreamweaver UltraDev 1.
Description
This function gets a comma-delimited string that contains the list of parameters that the
stored procedure takes.
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 stored procedure.
Returns
A comma-delimited string that contains the list of parameters that the stored procedure
requires. The parameters’ names, direction, and data type are included, separated by
semicolons (;).
Example
The code MMDB.getSPParamsAsString ("EmpDB","getNewEmployeesMakingAtLeast")
can return a string of form name
startDate;direction:in;datatype:date,
salary;direction:in;datatype:integer
.
In this example, the stored procedure,
getNewEmployeesMakingAtLeast, has two
parameters:
startDate and Salary. For startDate, the direction is in and the data type is
date. For salary, the direction is in and the data type is date.
MMDB.getTables()
Availability
Dreamweaver UltraDev 1.
000_DW_API_Print.book Page 95 Wednesday, July 20, 2005 11:58 AM