Specifications

The Database API 331
Returns
An array of parameter objects, each specifying the following set of properties:
Example
var paramNameObjs = MMDB.getSPParameters(connName,procName);
for (i = 0; i < paramNameObjs.length; i++)
{
var paramObj = paramNameObjs[i];
var tooltiptext = paramObj.datatype;
tooltiptext+=" ";
tooltiptext+=GetDirString(paramObj.directiontype);
}
MMDB.getSPParamsAsString()
Availability
Dreamweaver UltraDev 1
Description
Gets a comma-delimited string that contains the list of parameters that the stored procedure
takes.
Arguments
connName, procName
• 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.
• procName 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") could
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.
Property Name Description
name Name of the parameter (for example, @@lolimit)
datatype Datatype of the parameter (for example, smallmoney)
direction Direction of the parameter:
1– The parameter is used for input only.
2– The parameter is used for output only. In this case, you pass the
parameter by reference and the method places a value in it. You can use
the value after the method returns.
3– The parameter is used for both input and output.
4– The parameter holds a return value.