ColdFusion 9 brings four new data types to the html cfgrid.  As the docs state:

ColdFusion 9: Added boolean, date, numeric, and string_noCase to the
 type attribute values supported in HTML grids

Lets take a look at these new types.  Here's a sample query from the art table that I added a date to and called it, well, aDate:

I'll display these using the following cfgridcolumn tags:

<cfgridcolumn name="artname" type="string_noCase">
<cfgridcolumn name="isSold" type="boolean">
<cfgridcolumn name="price" type="numeric">
<cfgridcolumn name="aDate" type="date">

Whats cool is that ColdFusion or ExtJS (I'm not sure which) is going to automatically try and convert these types from the data where possible.  The grid looks like this:

A quick run through of the various types;

• string_noCase specifies that the column will be sorted without regards to case. 
• The boolean type will show a checkbox, checked if the boolean is true.  From this example you can see that it is smart enough to convert 0 and 1's into Boolean as well as true and false. 
• The price column is set to numeric which limits the editing of the column to just numbers. 
• Leaving the best for last is the date type which when editing displays a nice calendar option.

Overall some pretty cool additions that make the cfgrid tag more useful.

Here's the full code to generate the above:

<cfquery name="getArt" datasource="cfartgallery">
select ARTID, ARTNAME, DESCRIPTION, ISSOLD, PRICE, CURRENT_DATE aDate 
from ART 
</cfquery>
<cfdump var="#getArt#" top="10">

<cfform>
<cfgrid format="html" name="art" query="getArt" align="left" selectmode="edit">
	<cfgridcolumn name="artname" type="string_noCase">
	<cfgridcolumn name="isSold" type="boolean">
	<cfgridcolumn name="price" type="numeric">
	<cfgridcolumn name="aDate" type="date">
</cfgrid>
</cfform>

Around two years, just after the successful launch of ColdFusion 8, I emailed some of the top dogs on the Adobe ColdFusion team about features for ColdFusion 9.  These where my suggestions and whether they made CF9:

• An IDE.  ColdFusion Builder is here and one I've been happily using exclusively since its release. 
• Shorter Syntax/Full cfscript Support.  The shorter syntax was an idea of mine to merge scripting in a tagging syntax. Looking back I'm not sure exactly how it would have worked but I am happy to see much improved support for cfscript.  Writing a cfc in script syntax feels good and should help those picking up ColdFusion.
• cfspreadsheet.  Adobe nailed this one with the new tag and numerous Spreadsheet* functions.
• cfaudio/cfvideo.  My request was for recording and editing Flash movies and possibly other formats. A little disapointed although these features are availible with other tools in the Adobe arsenal.  cfmediaplayer is a useful addition to ease the playing of Flash movies.
• Built in ORM support.  The hibernate integration appears to be awesome so far.
• Stronger support for {} and []: Happy to see more uses for these useful short cuts.
• Optomize PDFs: Actually asked for this one later on but am delighted to see its inclusion.

The ColdFusion team did not listen just to me of course, from conversations I've had with them they listen to just about every blog post, review all ERs sent in and go out and talk to customers about their vision.  I've participated in the latter and they are very good sessions.

Overall I'm excited with the new features in ColdFusion 9 and pleased that my feedback was listened to (and mostly showed up in the final release) but I'm actually more excited about the features I did not suggest such as:

• Advanced Caching
• SharePoint Integration
• Office Integration (including document to pdf conversion)
• Java Portal Integration
• Enhancements to Components
• Integration with the Solr search engine
• Faster Flash Remoting
• ColdFusion as a Service

Congratulations to the whole ColdFusion team and all of those who have worked on the release of 9!