Adobe Dreamweaver API Reference CS5 Manual de usuario descargar pdf (Pagina 76)

100

101

DREAMWEAVER API REFERENCE

The database API

Last updated 8/27/2013

Note: Dreamweaver connects to and gets all the tables in the database whenever you modify a recordset. If the database

has many tables, Dreamweaver might take a long time to retrieve them on certain systems. If your database contains a

schema or catalog, you can use the schema or catalog to restrict the number of database items Dreamweaver gets at design

time. You must first create a schema or catalog in your database application before you can apply it in Dreamweaver.

Consult your database documentation or your system administrator.

Example

The following code gets a list of procedures:

var procObjects = MMDB.getProcedures(connectionName);

for (i = 0; i < procObjects.length; i++)

{

var thisProcedure = procObjects[i]

thisSchema =Trim(thisProcedure.schema)

if (thisSchema.length == 0)

{

thisSchema = Trim(thisProcedure.catalog)

}

if (thisSchema.length > 0)

{

thisSchema += "."

}

var procName = String(thisSchema + thisProcedure.procedure);

}

MMDB.getSPColumnList()

Availability

Dreamweaver UltraDev 1.

Description

This function gets a list of result set columns that are generated by a call to the specified stored procedure.

Property Name Description

schema Name of the schema that is associated with the object.

This property identifies the user that is associated with the stored procedure in the SQL database that the

getProcedures() function accesses. The database that this function accesses depends on the type of

connection.

• For ODBC connections, the ODBC data source defines the database. The DSN is specified by the dsn

property in the connection object (connName) that you pass to the

getProcedures() function.

• For OLE DB connections, the connection string names the database.

catalog Name of the catalog that is associated with the object (owner qualifier).

The value of the catalog property is defined by an attribute of the OLE DB driver. This driver attribute

defines a default

user.database property to use when the OLE DB connection string does not specify a

database.

procedure Name of the procedure.

1 2 ... 71 72 73 74 75 76 77 78 79 80 81 ... 532 533

Comentarios a estos manuales

Sin comentarios

Adobe Dreamweaver API Reference CS5 Manual de usuario Pagina 76

Comentarios a estos manuales

Relacionado con productos y manuales para Software Adobe Dreamweaver API Reference CS5