Adobe 38040334 API Reference - Page 66

DREAMWEAVER CS3 61 API Reference • 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. Returns An array of objects, one object for each column. Each object defines the following three properties for the column with which it is associated. Property Name name datatype definedsize nullable Description Name of the column (for example, price) Data type of the column (for example, small money) Defined size of the column (for example, 8) Indicates whether the column can contain null values Example The following example uses MMDB.getColumns() to set the tooltip text value: var columnNameObjs = MMDB.getColumns(connName,tableName); var databaseType = MMDB.getDatabaseType(connName);