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:
<!--#include file="../Connections/MyConnection1.asp"-->
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:
<!-- FileName="Connection_cf_dsn.htm" "dsn=products" -->
<!-- Type="ADO" -->
<!-- Catalog="" -->
<!-- Schema="" -->
<!-- HTTP="false" -->
<CFSET MM_MyConnection1_DSN
= "products">
<CFSET MM_MyConnection1_USERNAME
= "">
<CFSET MM_Product_USERNAME
= "">
<CFSET MM_MyConnection1_PASSWORD
= "">
000_DW_API_Print.book Page 108 Wednesday, August 20, 2003 9:14 AM
Summary of Contents for DREAMWEAVER MX 2004
Page 1: ...Dreamweaver API Reference...
Page 24: ...24 Contents...
Page 32: ......
Page 70: ...70 Chapter 5 Fireworks Integration...
Page 76: ...76 Chapter 6 Flash Integration...
Page 116: ...116 Chapter 9 The JavaBeans API...
Page 140: ......
Page 152: ...152 Chapter 11 Application...
Page 218: ...218 Chapter 12 Workspace...
Page 248: ...248 Chapter 13 Site...
Page 292: ...292 Chapter 14 Document...
Page 378: ...378 Chapter 17 Design...
Page 430: ...430 Chapter 18 Code...
Page 486: ...486 Index...
