Adobe Dreamweaver API Reference CS5 Uživatelský manuál stáhnout pdf (Strana 73)

100

101

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.

1 2 ... 68 69 70 71 72 73 74 75 76 77 78 ... 532 533

Komentáře k této Příručce

Žádné komentáře

Adobe Dreamweaver API Reference CS5 Uživatelský manuál Strana 73

Komentáře k této Příručce

Související produkty a manuály pro Software Adobe Dreamweaver API Reference CS5