WebReference.com - Chapter 4 from The Joy of Dreamweaver MX, from Osborne/McGraw-Hill (6/8) | WebReference

WebReference.com - Chapter 4 from The Joy of Dreamweaver MX, from Osborne/McGraw-Hill (6/8)

To page 1To page 2To page 3To page 4To page 5current pageTo page 7To page 8
[previous] [next]

The Joy of Dreamweaver MX: Chapter 4

HomeSite+ Integration

While it's true that Dreamweaver MX now incorporates many of the features of HomeSite and ColdFusion Studio, there are still times when you need the tools of an external code editor. If you selected the option to install HomeSite+ when you installed Dreamweaver MX, the integration of these two products is already enabled.

In this section, we'll learn to use a handy-dandy HomeSite+ tool that has yet to be assimilated into Dreamweaver MX: SQL Builder.

Remote Development Services (RDS)

Launch Dreamweaver MX and open the page we were working on earlier, Chapter4.htm. Choose File | Save As and save the file as Chapter4.cfm.

NOTE: This section requires ColdFusion MX Server. ASP users may want to sit this one out.

Before we can insert a query into the page, we need to edit the Site Definition for Chapter4. Choose Site | Edit Sites, and double-click Chapter4. Select the Testing Server category on the Advanced tab of the Site Definition dialog box. Choose ColdFusion from the Server Model drop-down menu and click OK. Click Done to close the Edit Sites dialog box.

Chapter4 is now defined as a ColdFusion site. In order to view the data sources defined in ColdFusion Administrator, open the Databases panel (Window | Databases) and click RDS Login.

Linking to Remote CF Data Sources

Enter the password you created when you installed ColdFusion MX and click OK. Dreamweaver MX uses Remote Development Services (RDS) to display your ColdFusion data sources in the Databases panel.

NOTE: ColdFusion Remote Development Services (RDS) is a component of ColdFusion Server used by ColdFusion Studio, HomeSite+, and Dreamweaver MX to provide HTTP-based access to files and databases. You can use RDS to manage files and databases on any local or remote server hosting ColdFusion, provided you have RDS login access. RDS is enabled in ColdFusion Administrator by default.

Open the Bindings panel (Window | Bindings) and choose Recordset (Query). Enter rsLocations in the Name text box, and choose the connGlobal data source we created in Chapter 1. Select LOCATIONS from the Table drop-down menu and click Test. The REGION_ID column consists of numbers, rather than geographical locations. To address this, we need to create a SQL statement that joins two related tables (LOCATIONS and REGION). This is where HomeSite+ comes in. Click OK, and then click OK again to close the Recordset dialog box.

Adding HomeSite+ Mappings

If it's not open already, open Chapter4.cfm in Dreamweaver MX and choose Edit | Edit with HomeSite+.

Because HomeSite+ is an advanced text editor, it doesn't feature a Design view like Dreamweaver MX. Instead, HomeSite+ consists of an Edit tab and a Browse tab. The Edit tab is akin to Code view in Dreamweaver MX. The Browse tab displays the current document using an internal browser. Before we can use the Browse feature, we have to add a server development mapping, as we did with TopStyle Pro.

Select Debug | Development Mappings (or press ALT-M) and choose your local server from the RDS Server drop-down menu. If you haven't configured your RDS Server yet, choose Add RDS Server from the drop-down menu. Enter an optional nickname for the server in the Description text box, and type localhost in the Host Name text box (if you're connecting to a remote RDS Server, enter its domain name or IP address). Under Macromedia RDS Security, enter the password you created when you installed ColdFusion MX and click OK.

Configuring the RDS Server

To create the development mapping for the Chapter4 site, click Add. As with TopStyle Pro, enter the physical path to the site's root folder in the HomeSite+ Path text box, and enter the URL it resolves to in the Browser Path text box. Click OK.

Chapter4 is added to the list of HomeSite+ mappings. Click OK to close the Remote Development Settings dialog box. Now select the Browse tab in HomeSite+. Chapter4.cfm is displayed as it appears in Internet Explorer.


To page 1To page 2To page 3To page 4To page 5current pageTo page 7To page 8
[previous] [next]

The Joy of Dreamweaver MX, By Paul Newman
Copyright (c) 2002 by The McGraw-Hill Companies

Created: September 16, 2002
Revised: September 16, 2002

URL: http://webreference.com/authoring/languages/html/joydreamweaver/chap4/6.html