1. In Flash Builder or Eclipse, select Window > Preferences > ColdFusion > RDS Configuration.

2. To configure the default localhost server, select localhost and specify the following:

   • Description

   • Host name (127.0.0.1)

   • Port number (8500 if you are using the built-in web server)

   • Context root, if necessary (For more information about the context root, see Installing ColdFusion guide.)

   • Password, which is the RDS password

3. To specify additional servers, click New, and specify the following:

   • Description, which can be any name you want

   • Host name (IP address or machine name)

   • Port number (8500 if you are using the built-in web server)

   • Context root, if necessary

     For more information about the context root, see Installing ColdFusion guide.

   • Password, which is the RDS password

4. To remove a server definition, select the server and click Remove.

5. To test a connection, select the server and click Test Connection.

Once you have configured the RDS connection to your CF servers, you can view the files, folders and data sources on RDS servers. Each RDS server appears as a node in the RDS Fileview and Dataview, with the name you specified when you configured the RDS server.

1. In Flash Builder, select Window > Other Views. In Eclipse, select Window > Show View > Other.

2. Select RDS.

3. To access the file system on the RDS server, select RDS Fileview.

4. To access data sources on the RDS server, select RDS Dataview.

1. Click the RDS Query Viewer icon on the RDS Dataview tab.

   The RDS Query Viewer opens in its own tab, which means that if you have other documents open, the RDS Query Viewer has focus.

2. Do one of the following:

   • Enter the SQL, and double-click the field names and table names as appropriate.

   • Click the Visual Query Builder button.

   For more information about using the Visual Query Builder, see Using Visual Query Builder.

3. To try the query, click Execute query.

   The first 50 records of the result set appear.

1. Expand a data source.

2. Double-click the columns to be named in the SELECT statement.

   As you select columns, the Query Builder creates the SELECT statement in the area at the lower edge of the pane.

3. If you select columns from more than one table, you must specify the column or columns used to join them by dragging a column from one table to the related column in the second table.

4. (Optional) Specify sort order by doing the following:

   1. Locate the column in the Properties panel.

   2. Click in the Sort Type cell of the column you want to sort by.

   3. Specify Ascending or Descending.

   4. (Optional) If you specify multiple sort columns, you specify precedence using the Sort Order cell.

5. (Optional) Specify selection criteria by doing the following:

   1. Locate the column in the Properties panel.

   2. Click in the Condition cell.

   3. Select WHERE.

   4. Specify WHERE clause criteria in the Criteria cell.

      Note: If you specify selection criteria, the Query Builder creates a WHERE clause. To use an INNER JOIN or other advanced selection criteria instead, you must code the SQL manually.

6. (Optional) To specify an aggregate function, GROUP BY, or an expression:

   1. Locate the column in the Properties panel.

   2. Click in the Condition cell.

   3. Select Group By or the aggregate function (such as COUNT).

7. (Optional) To specify SQL manually, type the SQL statement in the SQL pane.

   Note: You code SQL manually to use an INNER JOIN instead of a WHERE clause, use an OUTER JOIN, or use a database stored procedure.

8. (Optional) To specify the data type of a query parameter:

   1. Click the + button under Parameters.

   2. Enter the name of the parameter.

   3. Select the data type.

9. Review the SELECT statement that displays in the SQL pane, and use the Table and Properties panes to make adjustments, if necessary.

10. (Optional) Click Test Query.

11. Click Save.