Important ColdFusion Scheduler Fix in 7.0.2

If you make regular use of scheduled tasks in ColdFusion, you'll be happy to know that a nagging, intermittnet bug has been fixed. Bug #61272 had to do with the ColdFusion schedluer firing off scheduled tasks twice after a server reboot. You can download ColdFusion 7.0.2, which contains the fix.

Personally, I only ran into this issue once on one of my production servers, but it was a big problem when it hit. We have over 600 scheduled tasks on our server which generate customer reports which are emailed out on a daily basis. Customers were irritated with receiving two copies of each report, and the additional load on our server was not desirable either.

At the time, we "fixed" the problem by deleting all of the tasks and recreating them. We scripted the bulk delete/recreate, but it was still a bit of a pain. After that, we haven't run into the issue again. I've read other reports from users with the same problem, so it's good to know a permanent fix is now available.

The Best of CFGURU

Other than a blog post by Simon Horwith, I haven't seen much chatter regarding the new CFGURU blog. The CFGURU blog is a companion site to the private CFGURU mailing list. The site is moderated by Shlomy Gantz, with a charter to share useful discussions from the mailing list with the ColdFusion community at large.

There are currently only a handful of posts on the site, but you can expect a lot more great content as Shlomy compiles and publishes posts from the list.

Help Support CFEclipse

The CFEclipse team has done a fantastic job developing an open source, community driven IDE for ColdFusion developers. If you're using CFEclipse, you know exactly what I mean. If you aren't using CFEclipse, you owe it to yourself to give it a look.

That said, the team at CFEclipse is always looking for volunteers to help out with the project. Java skills are especially helpful. However, if you don't know Java and still want to contribute, there are several other ways you can help.

If you find that you just don't have the time to help technically, you can also contribute to the project financially. The CFEclipse team has put together a selection of branded CFEclipse merchandise that you can purchase. They have everything fron hats and t-shirts to coffee mugs and even a messenger bag.

CFUNITED Flickr Pool - 2006

With a little more than a month until the kick-off of CFUNITED, I figured I'd remind everyone that there's a Flickr pool for CFUNITED photos. There are currently 25 members, with over 150 photos posted from last year's event.

If you are going to this year's conference, sign up for the group (it's free) and share your conference pics. If you can't make it to CFUNITED this year, the Flickr pool is a great place to see what you are missing ;-)

JTOpen 5.1.1 Released

For all you ColdFusion junkies working with DB2 on iSeries/AS400's out there, IBM has just released version 5.1.1 of their open source JTOpen JDBC driver. You can download it from SourceForge.

cf_stockGrabber Custom Tag Updated to 3.01

cf_stockGrabber, a custom tag I wrote way back in 1997 when custom tags were first introduced in ColdFusion still has a lot of users today. The tag uses cfhttp to query Yahoo with a list of ticker symbols and returns the results as a query object which can then be used in a variety of ways.

There haven't been any changes to the tag since 2002. However, I've had several people contact me in the past week or so with problems related to certain ticker symbols. It turns out Yahoo made some changes to their feed which resulted in company names containing commas in certain instances. This in turn caused the tag to return an error as it was interpreting the comma as an extra delimiter and throwing the whole column count of the result set off.

This was easily fixed by adding a set of double quotes to the TEXTQUALIFIER attribute of the cfhttp tag. I've updated the tag on the Macromedia/Adobe Exchange with the changes. Here's the link to the latest version of a zip containing the file on my site:

cf_stockGrabber 3.01

User Interface Design Patterns from Yahoo Developer Network

I saw this one over on the Playfool blog. Apparently, Yahoo has a new Design Pattern Library over on their Developer Network website. JavaScript Source code and examples are available for several common UI design patterns including the following:

Drag and Drop Modules
Module Tabs
Navigation Tabs
Object Pagination
Search Pagination
Rating an Object
Writing a Review

Some of these are really cool. I especially like the drag and drop module as this is something I've been looking to do in a portal application we have. It will be interesting to see how the library develops as more people start contributing.

Finally! RDS Support For CFEclipse

One of the most requested features for CFEclipse is finally here. That's right, RDS support is now available from the Adobe Labs website. The engineers at Adobe have been collaborating with the CFEclipse team to bring RDS to the masses.

I personally know quite a few people who just couldn't make the switch from Homesite to CFEclipse because of the lack of RDS support (myself included), so now that it's finally here, there should be one less barrier keeping people from switching.

I've been using the plugin for a while now, and it is working rather well. In addition to the standard file browsing capabilities, there's also a nice dataview which allows you to visually build queries and generate SQL statements. Very handy.

If you've been on the fence about using CFEclipse before, download the latest build, download the RDS plugin, and give it another shot. There's an active and vibrant community coming up around CFEclipse as well, so there's plenty of opportunity to help shape and contribute to the ongoing development.

Back to the Philippines Again

ColdFusion related blogging is going to be slow for the next three weeks while I head to the Philippines for a non ColdFusion project I'm working on (although ColdFusion will ultimately interface with it). I'm working on a very exciting project centered around quite a bit of "new" technology. I'll probably be discussing some of the details as the project moves forward and I'm allowed to say more.

This is my second trip to the Philippines in the past 5 months, something I'm starting to get used to. If you want to keep up with what I'm up to, you may have better luck over on my food blog, Foo(d) Bar. I'm more likely to be logging updates there as I eat my way through the local Filipino dining scene.

If you're a ColdFusion developer and happen to be in the Makati area sometime between now and March 2nd, drop me a line!

Using the ColdFusion Report Builder – Part 2: Creating Charts in Reports

A coworker of mine, Jim Bambrough just had his second article published on the Adobe DevNet website. The new article, Using the ColdFusion Report Builder – Part 2: Creating Charts in Reports is a follow on to his earlier article Using the ColdFusion Report Builder—Part 1: Creating Reports and Subreports which I previously blogged about.

Jim's a talented developer and very knowledgable on the subject of reporting. His articles are a good read for anyone building reports using the ColdFusion Report Builder.