Database access functions
97
Returns
An array of view objects where each object has three properties:
catalog
,
schema
, and
view
.
Use
catalog
or
schema
to restrict or filter the number of views that pertain to an individual
schema name or catalog name that is defined as part of the connection information.
Example
The following example returns the views for a given connection value,
CONN_LIST.getValue()
:
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)
{
this= "."
}
views.push(String(this 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.
000_DW_API_Print.book Page 97 Wednesday, July 20, 2005 11:58 AM
Summary of Contents for DREAMWEAVER 8-DREAMWEAVER API
Page 1: ...Dreamweaver API Reference...
Page 16: ......
Page 28: ...28 The File I O API...
Page 38: ...38 The HTTP API...
Page 68: ...68 Flash Integration...
Page 100: ...100 The Database API...
Page 116: ...116 The JavaBeans API...
Page 144: ...144 The Source Control Integration API...
Page 146: ......
Page 254: ...254 Workspace...
Page 298: ...298 Site...
Page 354: ...354 Document...
Page 396: ...396 Page Content...
Page 488: ...488 Design...
Page 550: ...550 Code...