Diplaying Months in a CFchart tag using a query

As a new member of the Coldfusion Team at OHL logistics, I would like to say hello to everyone who participates in CFTips.net. I have only been working with CF for about two weeks, and I have run into a few problems here and there while developing my first CF App. One problem in particular, displaying months instead of numbers using a query and cfchart tag, caused a huge headache.

The solution to this problem is simple. Use the SQL function DATENAME(mm,'fieldname') and output the column in your cfchart tag.

Here is the Output:

post