Adobe Dreamweaver API Reference CS5 - Manual (Page 73)

68 DREAMWEAVER API REFERENCE
The database API
Last updated 8/27/2013
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
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.