Specifications

The Database API 333
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)
{
thisSchema += "."
}
views.push(String(thisSchema + thisView.view))
}
MMDB.showResultset()
Availability
Dreamweaver UltraDev 1
Description
Displays a dialog box that has the results of executing the specified SQL statement. The dialog
box displays a tabular grid where the header shows the column information and data of the result
set that is generated by the executed stored procedure. If the connection string or the SQL
statement is invalid, an error appears. You can use this function to verify the validity of the
SQL statement.
Arguments
connName, SQLstatement
• connName 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.
• SQLstatement 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")