beautypg.com

Findconnection() – Adobe Dreamweaver API Reference CS5 User Manual

Page 86

background image

81

DREAMWEAVER API REFERENCE

The database connectivity API

Last updated 8/27/2013

The

applyConnection()

function returns an HTML source within an include file. You can see examples of the

HTML source in

The generated include file

” on page 83. The

findConnection()

function takes the HTML source

and extracts its properties. You can implement

findConnection()

to use the search patterns in XML files to extract

the information that returns from

applyConnection()

. For an example of such an implementation, see the following

two JavaScript files:

The connection_ado_conn_string.js file is located in Configuration/Connections/ASP_Js folder.

The connection_common.js file is located in Configuration/Connections/Shared folder.

When the user opens a site, Dreamweaver goes through each file in the Connections folder, opens it, and passes the
contents to

findConnection()

. If the contents of a file match the criteria for a valid connection,

findConnection()

returns a connection object. Dreamweaver then lists all the connection objects in the Database Explorer panel.

When the user opens a connection dialog box and selects to create a new connection or duplicate or edit an existing
connection, Dreamweaver calls the

inspectConnection()

function and passes back the same connection object that

findConnection()

created. This process lets Dreamweaver populate the dialog box with the connection information.

When the user clicks OK in a connection dialog box, Dreamweaver calls the

applyConnection()

function to build

the HTML, which is placed in the connection include file that is located in the Configuration/Connections folder. The

applyConnection()

function returns an empty string that indicates there is an error in one of the fields and the dialog

box should not be closed. The include file has the default file extension type for the current server model.

When the user adds to the page a server behavior that uses the connection, such as a recordset or a stored procedure,
Dreamweaver adds a statement to the page that includes the connection include file.

findConnection()

Availability
Dreamweaver UltraDev 4.

Description
Dreamweaver calls this function to detect a connection in the specified HTML source and to parse the connection
parameters. If the contents of this source file match the criteria for a valid connection,

findConnection()

returns a

connection object; otherwise, this function returns a

null

value.

Argument

htmlSource

The htmlSource argument is the HTML source for a connection.

Returns
A connection object that provides values for a particular combination of the properties that are listed in the following
table. The properties for which this function returns a value depend on the document type.

Property

Description

name

Name of the connection

type

If

useHTTP

is

false

, indicates which DLL to use for connecting to database at runtime

string

Runtime connection string. For ADO, it is a string of connection parameters; for JDBC, it is a
connection URL

dsn

Data source name used for ODBC or Cold Fusion runtime connections