Excerpted from CF Advisor, September 1999.

Quick Access to Tag Help:

Did you know that in Studio you can place the cursor on a tag and press F1, to view the help file for that tag? This would be the same help shown in the help window, but you need not drill down to find the reference. And in 4.01, this functionality has been extended to support CF tags and functions.

Handling Errors in Studio Query Building or Debugging Tools

The query building and interactive debugging tools in Studio each work in conjunction with the RDS (remote development services) feature, whether you're working with databases or templates that are stored locally or against a remote server. You can easily add a new RDS server to either of the lists of servers offered in these two tools, but you cannot edit them.

If a mistake is causing your selection of one of these listed servers to fail, you may need to edit it. You can do so using the Remote Files tab, which is the second tab on the resource toolbar at the lower left of Studio's screen (by default).

Easier Insertion of Dates with CFINSERT/CFUPDATE

When you're inserting date/time values into a database, you want to be careful about deciding whether the date should be hardcoded into the form (perhaps as a hidden field) or whether it should be computed at the time of the data entry. These could each present very different date/time values.

One challenge when using CFINSERT is that you typically rely on the form to present all data for insert into the database, so you may feel restricted to hard-coding the date/time into the form.

In 4.01, this problem has been addressed. When using CFINSERT or CFUPDATE, you can define a form field with the name of a table column that will hold a date or time, and you can now store a special "value" for that field on the form: "currentdate()", or "currentdatetime()". Note that you do NOT wrap this in pound signs in the form. It's a special string value interpreted during the CFINSERT/CFUPDATE on the action page. And more important, the value is computed to be that at the time of the insert or update, which is usually what one intends.

This is documented only in the 4.0.1 documentation update page (not in the CFML reference for the tags). Also, the doc does not mention the currentdatetime() existing, but testing showed it to work as expected.

Tips Contents:

| Home | ColdFusion | Articles | Presentations
| User Groups | Other Resources | Press Releases | Company

© 1998-2024, Charles Arehart, SysteManage
Our Practice Makes You Perfect