Specifications

The Database API 325
MMDB.getColumnAndTypeList()
Availability
Dreamweaver UltraDev 1
Description
Gets a list of columns and their types from an executed SQL SELECT statement.
Arguments
connName, statement
• 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.
• statement is the SQL SELECT statement to execute.
Returns
An array of strings that represents a list of columns (and their types) that match the SELECT
statement, or an error if the SQL statement is invalid or the connection cannot be made.
Example
The code var columnArray = MMDB.getColumnAndTypeList("EmpDB","Select * from
Employees")
returns the following array of strings:
columnArray[0] = "EmpName"
columnArray[1] = "varchar"
columnArray[2] = "EmpFirstName"
columnArray[3] = "varchar"
columnArray[4] = "Age"
columnArray[5] = "integer"
MMDB.getColumnList()
Availability
Dreamweaver UltraDev 1
Description
Gets a list of columns from an executed SQL SELECT statement.
Arguments
connName, statement
• 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.
• statement is the SQL SELECT statement to execute.
Returns
An array of strings that represents a list of columns that match the SELECT statement, or an error
if the SQL statement is invalid or the connection cannot be made.