98
Chapter 7: The Database API
Returns
An array of parameter objects, each specifying the following set of properties:
Example
The following example retrieves the parameter objects for the specified procedure and creates a
tooltip for each object using its properties.
var paramNameObjs = MMDB.getSPParameters(connName,procName);
for (i = 0; i < paramNameObjs.length; i++)
{
var paramObj = paramNameObjs[i];
var tooltiptext = paramObj.datatype;
tool=" ";
tool=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 (;).
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.
000_DW_API_Print.book Page 98 Wednesday, August 20, 2003 9:14 AM
Содержание DREAMWEAVER MX 2004-DREAMWEAVER API
Страница 1: ...Dreamweaver API Reference...
Страница 24: ...24 Contents...
Страница 32: ......
Страница 70: ...70 Chapter 5 Fireworks Integration...
Страница 76: ...76 Chapter 6 Flash Integration...
Страница 116: ...116 Chapter 9 The JavaBeans API...
Страница 140: ......
Страница 152: ...152 Chapter 11 Application...
Страница 218: ...218 Chapter 12 Workspace...
Страница 248: ...248 Chapter 13 Site...
Страница 292: ...292 Chapter 14 Document...
Страница 378: ...378 Chapter 17 Design...
Страница 430: ...430 Chapter 18 Code...
Страница 486: ...486 Index...