all groups > coldfusion flash integration > may 2006 >
You're in the

coldfusion flash integration

group:

date mask does not work with binded flash data



date mask does not work with binded flash data BosDog
5/9/2006 6:34:31 PM
coldfusion flash integration: i've researched everywhere... tried everything... learned that this bug was
"supposedly" fixed but in Coldfusion 7.0.1 it doesn't seem to be the case. Here
is my text box:

<cfinput type="datefield" name="edit_eff_date"
bind="{(listingGrid.selectedItem!=undefined)?listingGrid.selectedItem.SIP_EFFECT
IVE_DT:''}" label="SIP Effective Date:" mask="mm/dd/yyyy"/>

But the date is showing as Wed Apr 19 00:00:00 GMT -04 which is just plain
awful...

I'm coming from oracle (my demo is based off the real estate example)... maybe
there is something w/ oracle dates b/c in the example they're using ms access
and seem to have no problems.

Someone please help...
Re: date mask does not work with binded flash data BosDog
5/9/2006 9:11:25 PM
RE: date mask does not work with binded flash data Tad
2/5/2007 8:19:34 PM
Spent a lot of time trying to figure out binding a datefield in a &ltcfsavecontent&gt variable so that the formatting would be displayed as 'MM/DD/YYYY'. We are an Oracle shop where I work also. I found that the easiest way to accomplish this is in the query within the CFC. When selecting the data from the query just use "to_char(datefield_name, 'MM/DD/YYYY') aliasname". Then in the &ltcfgridcolumn&gt for that particular datefield you would reference the aliasname (example: name="CREATEDATE"). Remember to use capital letters for Oracle as column names are rendered as all caps. The &ltcfsavecontent&gt variable would also reference the alias as well (ex: "Create Date: &nbsp;&nbsp;\t" + gridName.selectedItem.CREATEDATE) and also the &ltcfinput&gt on your edit form. When the data is displayed it should already be formatted as 'MM/DD/YYYY'. Hope this helps

From http://www.developmentnow.com/g/66_2006_5_0_0_752141/date-mask-does-not-work-with-binded-flash-data.ht

Posted via DevelopmentNow.com Group
AddThis Social Bookmark Button