The Resource tab is absolutely indispensable in Studio. It consists of eight tabs that enable you to:
• Manage your files locally and remotely
• Manage your databases and SQL queries
• View your document links
• Organize and create reusable bits of code
• Access Help information
• Work interactively with HrML and CFML tags
Table 20.1 discusses the function of each tab in the Resource tab .
The Local Files tab is self-explanatory. After you’ve selected the drive and the folder from which you want to view files, just double-click the files to open them in the work area.
However, there are some document tab indicators that you should be aware of after you ipen files in Studio. Saved documents show only the document name in the document tab. Files that have not been saved have an additional X on them, and files that are read-only have an additional red dot on them. Figure 20.3 illustrates these indicators.
You can access remote files in two ways: You can use FI’P to create, open, modify, and save files on a remote server, or you can use RDS to connect to a ColdFusion server to access files and databases through HTIP. To access files through FI’P or RDS, selectAllaire FI’P &RDS from the list of file sources in the Files tab. You can easily add an FIP or an RDS server by right-clicking in the upper pane of the tab and choosing the appropriate option from the shortcut menu. You will be presented with a relevant dialog box’ asking for pertinent information to add the server. Follow the prompts in the dialog box to add the server.
You can easily save files to the server by following these simple steps:
1. Open the file in your work area.
2. Choose File>Save Remote Copy.
3. Select the server, drive, and directory into which you want to save your file, enter the filename, and then press the Save button.
Database Tab to view databases on a Cold Fusion server, you have to configure an RDS server by using the Remote Files tab or by selecting Add RDS Server from the drop-down box at the top of the Database tab. After the RDS server is configured, you must select it
from the drop-down box to view all the databases registered as system data sources on the server.
‘The real power of the Database tab is that it enables you to easily manipulate your tables and columns by giving you easy access to the SQL Query Builder. Follow the so below to open the Query Builder .a.nd creat.,e a SQL SELECT statement:
1. Right-click one of the tables that you waritto use in your SELECT statement and rchoose.New Query from the shortcut menu. The Query Builder should appear with the appropriate table open.
2. Right-click anywhere in the Table pane and select Add Table, and then choose the’ table you would like to add jo the query. That table should also appear in the Table pane and the table name will be added to the FROM clause of your SQL statement in the S<;2Lpane,
3. Selecting columns for use in your SQL statement is also easy. Just double-click-the column name and it will be added to the Properties pane and the SELECT statement in the SQL pane.
4.Creating joins in the Query Builder is also a snap. After you have the two tables open that you would like to join, all you have to do is click the field you would like to join in one table and drag it and drop it onto the corresponding field in the other table. As you do that, you will see the join statement added in the SQL pane.
5. After your 6QL statement is complete, you can run the query to test it by clicking ‘the Run Query button on the Query toolbar.
6. When you are ready to save your query, click the Close Query Builder button on the Query toolbar. You will be prompted to save the query and namelt. Give it a name but do not insert it into your template. You will be returned to the Studio interface.
7. You will now see your new query listed under the Queries folder in your data source listing.
8. To use your query in your Cold Fusion template, simple click it in the Database tab and drag it to the appropriate area of your template in the-Edit pane of your work area and drop it. The SQL statement will be inserted in your template with the appropriate CFQUERYtags surrounding it
Studio projects are a wonderful way to keep your team projects and even your individual projects organized. You can also perform maintenance functions such as global search-and-replaces and link verification on all the files in your projects because project files are viewed as a Unit by Studio. After you have created a Studio project, you can easily FTP it to the server-Studio j.seven smart enough to upload only those files that have changed since the last time you uploaded the project. Take the following steps to create a Studio project:
1. Click the New Project button at the top of the Projects tab. The New Projects dialog box will appear.
2. Type a name for your project and then locate it on your local machine. Press the. OK button when you are done.
3. The project appears in the Projects tab with folders listed in the top pane and files .listed in the bottom pane.
4. When you are ready to upload your files to your server, click the Upload Project button on the Projects tab toolbar. Choose the server and location to which you want to upload your file and be sure to select all the appropriate check boxes in the dialog box.