Ray Camden, Ben Forta, and Sean Corfield have all blogged about the new features in cfquery such as the new result attribute/structure and the ability to introspect query meta data using getMetaData(). I thought I'd tie all three of these posts together with a visual example of just what you get. Consider the following query:

Rather than rehash the other posts, a picture is worth a thousand words:

Result Struct

struct
CACHED	false
COLUMNLIST	ARTID,ARTISTID,ARTNAME,DESCRIPTION,ISSOLD,LARGEIMAGE,MEDIAID,PRICE
EXECUTIONTIME	10
RECORDCOUNT	55
SQL	SELECT * FROM art

Query Meta Data

array
1	struct IsCaseSensitive NO Name ARTID TypeName INT
2	struct IsCaseSensitive NO Name ARTISTID TypeName INT
3	struct IsCaseSensitive NO Name ARTNAME TypeName VARCHAR
4	struct IsCaseSensitive NO Name DESCRIPTION TypeName LONGCHAR
5	struct IsCaseSensitive NO Name PRICE TypeName CURRENCY
6	struct IsCaseSensitive NO Name LARGEIMAGE TypeName VARCHAR
7	struct IsCaseSensitive NO Name MEDIAID TypeName INT
8	struct IsCaseSensitive NO Name ISSOLD TypeName BIT

In case you haven't already discovered them yet, Macromedia has made available a HomeSite + CFMX 7 Updater. The updater contains tag definitions and help files for the new CFMX 7 release.

This one seems to have slipped under the radar, as I couldn't find any other blog references to it...

Developer Resource Kit 10 (DRK 10) is now available (has been since 1/27/05). Macromedia recently announced that they are discontinuing DevNet subscriptions, and will no longer produce a DRK after DRK 13. Searching Macromedia's web site doesn't turn up much info on DRK 10. If you are a DevNet subscriber, and are interested in knowing what's in this release, here's the info. Note that Macromedia no longer sellse DRKs outside of the DevNet subscription.

Flash

• Component: Expanding Pod
• Component: Localizer
• Library: RSS Library

Dreamweaver Extensions:

• WA Auto Spell Check
• Music Player Flash Element
• PHP 5 Edit Operation
• MX Kollection
• ActionScript Code Hints

ColdFusion MX

• Sample Application: PL-ease - product life-cycle management tool built on Ray Camden's Lighthouse bug tracking tool from DRK 4

It's official, Macromedia ColdFusion MX 7.0 has been officially released. I'll blog much more regarding the new featues/functionality when I get over the Philadelphis Eagles Superbowl loss, and get into the office tomorrow...

www.CFCZone.org has moved to a new host. We're now running the site on an excellent server provided by CFXHosting. If you're still seeing the Mindtool banner at the bottom of the page, you probably need to flush your DNS cache.

On a related note, the CFCDev mailing list is also migrating. As I type this, I'm still waiting for the MX records to update. I've already updated all 570+ regular subscribers, and I'm hoping for a relatively smooth transition of the list.

There is one small problem, though. We have about 170 or so Digest subscribers on the old list. Unfortunately, our new (free) listserv software doesn't support digest subscriptions (I have no idea why). So, we've got to figure out what to do with these users. The choices appear to be to convert them to regular subscribers, unsubscribe them, or start asking for donations to purchase a better listserv app.