MACROMEDIA COLDFUSION 4.5-CFML LANGUAGE Manuel d'utilisateur télécharger pdf (Page 23)

23Writing CFX Tags with Java

Listing 30.4 (continued)

<html>

<head>

<title>Database Metadata</title>

</head>

<body>

<h2>Database Metadata</h2>

<!---

Get infomration about the tables in the database

--->

<CFX_DatabaseMetaData

ACTION=”GetTables”

USERNAME=”Admin”

PASSWORD=””

DRIVER=”sun.jdbc.odbc.JdbcOdbcDriver”

CONNECT=”jdbc:odbc:ows”

NAME=”TablesQuery”>

<!---

Provide drop-down list of tables

--->

<cfform action=”DatabaseMetaDataDemo.cfm”

method=”POST”>

<p>

Select Table:

<cfselect name=”TableName”

query=”TablesQuery”

value=”TABLE_NAME”

selected=”#FORM.TableName#”

onChange=”this.form.submit()”/>

</cfform>

<!---

If a table name has been selected

--->

<h3>Columns in Table #TableName#</h3>

</cfoutput>

<!---

Get information about the selected table’s columns

--->

<CFX_DatabaseMetaData action=”GetColumns”

username=”Admin”

password=””

driver=”sun.jdbc.odbc.JdbcOdbcDriver”

connect=”jdbc:odbc:ows”

dbtablename=”#TableName#”

name=”FilmsMetaData”>

<!---

Display information returned by the CFX tag

--->

1 2 ... 18 19 20 21 22 23 24 25 26 27 28 ... 43 44

Commentaires sur ces manuels

Pas de commentaire

MACROMEDIA COLDFUSION 4.5-CFML LANGUAGE Manuel d'utilisateur Page 23

Commentaires sur ces manuels