User Guide

92 Chapter 7: The Database API
MMDB.getColumnList()
Availability
Dreamweaver UltraDev 1.
Description
This function gets a list of columns from an executed SQL SELECT statement.
Arguments
connName, statement
• 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 statement argument 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.
Example
The code var columnArray = MMDB.getColumnList("EmpDB","Select * from
Employees")
returns the following array of strings:
columnArray[0] = "EmpName"
columnArray[1] = "EmpFirstName"
columnArray[2] = "Age"
MMDB.getColumns()
Availability
Dreamweaver MX, arguments updated in Dreamweaver MX 2004.
Description
This function returns an array of objects that describe the columns in the specified table.
Arguments
connName, tableName
• The connName argument is the connection name. This value identifies the connection
containing the string that Dreamweaver should use to make a database connection to a live
data source.
• The tableName argument is the table to query.
000_DW_API_Print.book Page 92 Wednesday, August 20, 2003 9:14 AM