Adobe Dreamweaver API Reference CS5 Manuale Utente Scaricare il pdf (Pagina 79)

100

101

DREAMWEAVER API REFERENCE

The database API

Last updated 8/27/2013

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;

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

date.

MMDB.getTables()

Availability

Dreamweaver UltraDev 1.

Description

This function gets a list of all the tables that are defined for the specified database. Each table object has three

properties:

table, schema, and catalog.

1 2 ... 74 75 76 77 78 79 80 81 82 83 84 ... 532 533

Commenti su questo manuale

Nessun commento

Adobe Dreamweaver API Reference CS5 Manuale Utente Pagina 79

Commenti su questo manuale

Prodotti e manuali riguardandi Software Adobe Dreamweaver API Reference CS5