User Guide

ManualsBrandsMacromedia ManualsOtherDREAMWEAVER MX 2004-DREAMWEAVER API REFERENCE

101

102

103

104

105

106

107

108

109

110

108 Chapter 8: The Database Connectivity API

The generated include file

The include file that applyConnection() generates declares all the properties of a

connection.The filename for the include file is the connection name and has the file extension

that is defined for the server model associated with the current site.

Note: Connections are shared, so set the allowMultiple value to false. This ensures that the

connection file is included in the document only once and that the server script remains in the page if

any other server behaviors use it.

The following sections illustrate some sample include files that applyConnection() generates for

various default server models.

Note: To create a new connection include file format, you need to define a new EDML mapping file,

which should be similar to connection_includefile.edml, as shown in “The definition file for your

connection type” on page 109.

ASP JavaScript

The ASP and JavaScript include file should be named MyConnection1.asp, where

MyConnection1 is the name of the connection. The following sample is an include file for an

ADO connection string:

// Filename="Connection_ado_conn_string.htm"

// Type="ADO"

// HTTP="true"

// Catalog=""

// Schema=""

var MM_MyConnection1_STRING = "dsn=pubs";

The server behavior file includes this connection by using the relative file include statement, as

shown in the following example:

ColdFusion

When you use UltraDev 4 ColdFusion, Dreamweaver relies on a ColdFusion include file to get a

list of data sources.

Note: For regular Dreamweaver ColdFusion, Dreamweaver ignores any include files and, instead,

makes use of RDS to retrieve the list of data sources from ColdFusion.

The UltraDev 4 ColdFusion include file should be named MyConnection1.cfm, where

MyConnection1 is the name of your connection. The following example shows the include file

for a ColdFusion connection to a product table:

000_DW_API_Print.book Page 108 Wednesday, August 20, 2003 9:14 AM