Date Mask in CFGRIDCOLUMN - CFMX 7

[geokid]

Hello, I'm using CFGRID inside of a CFFORM format='flash'. It's pretty sweet
functionality. Just got CFMX 7 2 days ago and I'm loving it already! :>
However, I can't get the date mask to work in my flash-formatted CFGRID
column. When I don't have the mask attribute, the column displays the
date/time that it pulled out of the database query just fine (date shows as
i.e. 2004-08-21 17:20:42). However, if I put in the mask attribute (mask='MMM
DD YYYY'), all i get in the date column is MMM DD YYYY - literally. I even
tried the mask in the example from Macromedia LiveDocs about this (see url:
[url]http://www.macromedia.com/livedocs/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/h[/url]
tml/wwhelp.htm?context=ColdFusion_Documentation&fi le=00000267.htm#3842575)
and even that example shows me the 'mask code' instead of the date formatted by
the mask. I've attached my code below. Any ideas what is going wrong?
Thanks, Margaret

<CFFORM name="buySellForm" format="flash" height="450" >
<CFGRID name="listingsGrid" query="buySellListings" rowheaders="no">
<CFGRIDCOLUMN name="DatePosted" header="DatePosted" mask="MMM D YYYY">
<CFGRIDCOLUMN name="Item" header="Item" type="string_nocase">
</CFGRID>
</CFFORM>

[Mike Nimer]

What's the data type in the database of the datePosted column?
---nimer


"geokid" <webforumsuser@macromedia.com> wrote in message
news:cvdqgi$jmh$1@forums.macromedia.com...

> Hello, I'm using CFGRID inside of a CFFORM format='flash'. It's pretty
> sweet
> functionality. Just got CFMX 7 2 days ago and I'm loving it already! :>
> However, I can't get the date mask to work in my flash-formatted CFGRID
> column. When I don't have the mask attribute, the column displays the
> date/time that it pulled out of the database query just fine (date shows
> as
> i.e. 2004-08-21 17:20:42). However, if I put in the mask attribute
> (mask='MMM
> DD YYYY'), all i get in the date column is MMM DD YYYY - literally. I
> even
> tried the mask in the example from Macromedia LiveDocs about this (see
> url:
> [url]http://www.macromedia.com/livedocs/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/h[/url]
> tml/wwhelp.htm?context=ColdFusion_Documentation&amp;fi le=00000267.htm#3842575)
> and even that example shows me the 'mask code' instead of the date
> formatted by
> the mask. I've attached my code below. Any ideas what is going wrong?
> Thanks, Margaret
>
> <CFFORM name="buySellForm" format="flash" height="450" >
> <CFGRID name="listingsGrid" query="buySellListings" rowheaders="no">
> <CFGRIDCOLUMN name="DatePosted" header="DatePosted" mask="MMM D
> YYYY">
> <CFGRIDCOLUMN name="Item" header="Item" type="string_nocase">
> </CFGRID>
> </CFFORM>
>