WebReference.com - Chapter 4 from The Joy of Dreamweaver MX, from Osborne/McGraw-Hill (6/8)
The Joy of Dreamweaver MX: Chapter 4
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
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.
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 (
REGION). This is
where HomeSite+ comes in. Click OK, and then click OK again to close the Recordset
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.
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.
The Joy of Dreamweaver MX, By Paul Newman
Copyright (c) 2002 by The McGraw-Hill Companies
Created: September 16, 2002
Revised: September 16, 2002