MACROMEDIA DREAMWEAVER 8-DREAMWEAVER API - Page 89

Database access functions 89
MMDB.getColumnsOfTable()
Availability
Dreamweaver UltraDev 1.
Description
This function gets a list of all the columns in the specified table.
Arguments
connName, tableName
■ 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 tableName argument is the name of a table in the database that is specified by the
connName argument.
Returns
An array of strings where each string is the name of a column in the table.
Example
The statement MMDB.getColumnsOfTable ("EmpDB","Employees"); returns the
following strings:
["EmpID", "FirstName", "LastName"]
MMDB.getPrimaryKeys()
Availability
Dreamweaver MX.
Description
This function returns the column names that combine to form the primary key of the named
table. A primary key serves as the unique identifier for a database row and consists of at least
one column.
Arguments
connName, tableName
■ 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.
000_DW_API_Print.book Page 89 Wednesday, July 20, 2005 11:58 AM