MACROMEDIA COLDFUSION 4.5-CFML LANGUAGE Uživatelský manuál stáhnout pdf (Strana 16)

16 CHAPTER 30 Extending ColdFusion with CFX

Table 30.11 (continued)

ATTRIBUTE DESCRIPTION

dbschema Optional. The name of the database schema. Not all database systems

have the notion of a schema; for Access databases, specifying this

attribute will generate an error. For SQLServer databases, the schema

is often

dbo. Can be used for all actions except GetCatalogs and

GetSchemas.

dbtablename Optional. The name of the table you want to get information about.

Omit or leave blank for all tables. Can be used for

GetColumns,

GetTables, GetViews, GetIndexInfo, and GetPrimaryKeys.

dbcolumnname Optional. The name of the column you want information about. Omit

or leave blank for all columns. Can be used for

GetColumns and

GetProcedureColumns.

dbprocedurename Optional. The name of the stored procedure you want information

about; omit or leave blank for all procedures. Can be used for

GetProcedures or GetProcedureColumns.

Table 30.12 shows the various actions you can specify for the tag’s action attribute. The query

object returned by the tag will contain different information based on which action you choose,

as shown in this table.

Table 30.12 Information Returned by <CFX_DatabaseMetaData> Actions

ACTION DESCRIPTION COLUMNS RETURNED

GetTables TABLE_CAT, TABLE_NAME,

TABLE_SCHEM, and TABLE_TYPE

GetViews Same as GetTables, except for views. TABLE_CAT, TABLE_NAME,

TABLE_SCHEM, and TABLE_TYPE

GetColumns COLUMN_NAME

, COLUMN_SIZE,

IS_NULLABLE, SQL_DATA_TYPE,

TABLE_CAT, TABLE_NAME,

TABLE_SCHEM, and TYPE_NAME

GetCatalogs

A listing of catalogs (databases). TABLE_CAT

GetSchemas

A listing of schemas. TABLE_SCHEM

GetProcedures PROCEDURE_NAME

A listing of all stored procedures

in the database.

A listing of columns. All columns

in the entire database will be

returned unless you specify a

DBTABLENAME (or DBSCHEMA or

DBCATALOG).

A listing of tables in the

database. The returned query

includes these columns: By

default, all tables are returned;

you can ﬁlter the list using the

DBCATALOG, DBSCHEMA, or

DBTABLENAME attributes.

1 2 ... 11 12 13 14 15 16 17 18 19 20 21 ... 43 44

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

Žádné komentáře

MACROMEDIA COLDFUSION 4.5-CFML LANGUAGE Uživatelský manuál Strana 16

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