Macromedia dreamweaver 8-using dreamweaver User Manual
664
Chapter 30: Optimizing the Workspace for Visual Development
Restricting database information
displayed in Dreamweaver
displayed in Dreamweaver
Advanced users of large database systems like Oracle should restrict the number of database
items retrieved and displayed by Dreamweaver at design time. An Oracle database may
contain items that Dreamweaver cannot process at design time. You can create a schema in
Oracle and use it in Dreamweaver to filter out unnecessary items at design time.
items retrieved and displayed by Dreamweaver at design time. An Oracle database may
contain items that Dreamweaver cannot process at design time. You can create a schema in
Oracle and use it in Dreamweaver to filter out unnecessary items at design time.
Other users may benefit from restricting the amount of information Dreamweaver retrieves at
design time. Some databases contain dozens or even hundreds of tables, and you might not
want Dreamweaver to list them all while you work. A schema or catalog can restrict the
number of database items Dreamweaver gets at design time.
design time. Some databases contain dozens or even hundreds of tables, and you might not
want Dreamweaver to list them all while you work. A schema or catalog can restrict the
number of database items Dreamweaver gets at design time.
You must create a schema or catalog in your database system before you can apply it in
Dreamweaver. Consult your database system documentation or your system administrator.
Dreamweaver. Consult your database system documentation or your system administrator.
You cannot apply a schema or catalog in Dreamweaver if you’re developing a
ColdFusion application.
ColdFusion application.
To apply a schema or catalog in Dreamweaver to an application other than
ColdFusion:
ColdFusion:
1.
Open a dynamic page in Dreamweaver; then open the Databases panel (Window >
Databases).
Databases).
If the database connection already exists, a list of connections appears in the panel.
2.
Right-click (Windows) or Control-click (Macintosh) the connection, and select Edit
Connection from the pop-up menu. The dialog box appropriate for the connection
appears.
Connection from the pop-up menu. The dialog box appropriate for the connection
appears.
If the connection does not exist, click the Plus (+) button at the top of the panel and create
it. For more information, see
it. For more information, see
3.
In the dialog box for the connection, click Advanced.
The Restrict dialog box appears.
4.
Specify your schema or catalog.
5.
Click OK.
NO
TE
You cannot create a schema or catalog in Microsoft Access.