Adobe Dreamweaver API Reference CS5 Manual do Utilizador descarregar pdf (Página 81)

100

101

DREAMWEAVER API REFERENCE

The database API

Last updated 8/27/2013

var viewObjects = MMDB.getViews(CONN_LIST.getValue())

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

{

thisView = viewObjects[i]

thisSchema = Trim(thisView.schema)

if (thisSchema.length == 0)

{

thisSchema = Trim(thisView.catalog)

}

if (thisSchema.length > 0)

{

thisSchema += "."

}

views.push(String(thisSchema + thisView.view))

}

MMDB.showResultset()

Availability

Dreamweaver UltraDev 1.

Description

This function displays a dialog box that contains the results of executing the specified SQL statement.The dialog box

displays a tabular grid in which the header provides column information that describes the result set. If the connection

string or the SQL statement is invalid, an error appears. This function validates the SQL statement.

Arguments

connName, SQLstatement

• 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 SQLstatement argument is the SQL SELECT statement.

Returns

Nothing. This function returns an error if the SQL statement or the connection string is invalid.

Example

The following code displays the results of the executed SQL statement:

MMDB.showResultset("EmpDB","Select EmpName,EmpFirstName,Age ¬

from Employees")

MMDB.showSPResultset()

Availability

Dreamweaver UltraDev 1.

1 2 ... 76 77 78 79 80 81 82 83 84 85 86 ... 532 533

Comentários a estes Manuais

Sem comentários

Adobe Dreamweaver API Reference CS5 Manual do Utilizador Página 81

Comentários a estes Manuais

Manuais e produtos relacionados com Software Adobe Dreamweaver API Reference CS5