![MACROMEDIA DREAMWEAVER MX 2004-DREAMWEAVER API Скачать руководство пользователя страница 93](http://html1.mh-extra.com/html/macromedia/dreamweaver-mx-2004-dreamweaver-api/dreamweaver-mx-2004-dreamweaver-api_reference_3336554093.webp)
Database access functions
93
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.
Example
The following example uses
MMDB.getColumns()
to set the tooltip text value:
var columnNameObjs = MMDB.getColumns(connName,tableName);
var databaseType = MMDB.getDatabaseType(connName);
for (i = 0; i < columnNameObjs.length; i++)
{
var columnObj = columnNameObjs[i];
var columnName = columnObj.name;
var typename = columnObj.datatype;
if (dwscripts.isNumber(typename))
{
// it already is a num
typename = dwscripts.getDBColumnTypeAsString(typename, databaseType);
}
var tooltiptext = typename;
}
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.
Property Name
Description
name
Name of the column (for example,
price
)
datatype
Data type of the column (for example,
small money
)
definedsize
Defined size of the column (for example,
8
)
nullable
Indicates whether the column can contain
null
values
000_DW_API_Print.book Page 93 Wednesday, August 20, 2003 9:14 AM
Содержание DREAMWEAVER MX 2004-DREAMWEAVER API
Страница 1: ...Dreamweaver API Reference...
Страница 24: ...24 Contents...
Страница 32: ......
Страница 70: ...70 Chapter 5 Fireworks Integration...
Страница 76: ...76 Chapter 6 Flash Integration...
Страница 116: ...116 Chapter 9 The JavaBeans API...
Страница 140: ......
Страница 152: ...152 Chapter 11 Application...
Страница 218: ...218 Chapter 12 Workspace...
Страница 248: ...248 Chapter 13 Site...
Страница 292: ...292 Chapter 14 Document...
Страница 378: ...378 Chapter 17 Design...
Страница 430: ...430 Chapter 18 Code...
Страница 486: ...486 Index...