Status/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): / ext-user (Anit Kumar Panda)
Created: 06/01/2016
Components: AJAX, UI Components
Versions: 11.0
Failure Type: Incorrect w/Workaround
Found In Build/Fixed In Build: 296330 /
Priority/Frequency: Major / Some users will encounter
Locale/System: English,Japanese / Mac 10 All,Win XP All
Vote Count: 0
From Email:-
According to explanation for mask pattern:
https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-tags/tags-g-h/cfgridcolumn.html
"A mask pattern that controls the character pattern that the form displays or allows users to input and sends to ColdFusion."
Now, the patch is only fix the form display. Datatype input and sent to CF is not the same as the user have input in the form.
Regarding mask attribute for cfgridcolumn, we request:
1.the form display should be kept even it is not default format. Note that this is fixed by the patch for 4113472.
2. the input format should be also y/m/d. On current version, input format should be English format like 'September, 2 2005 00:00:00' and it cannot be other format '2005/9/2'.
3. The data format sent to CF should be also y/m/d. On current version, data sent to CF is 'Sat Feb 05 2005 00:00:00 GMT+0900 ' .
To confirm above behavior, please try following steps:
1. Request the attached cfgrid2.cfm on CF11 with the patch hf1100-4113472.jar.
2. Click the cell of "2005/09/02" of "myDate" column.
Observed 1:
Data get English format 'September, 2 2005 00:00:00' from "2005/09/02".
Data cannot be edit in y/m/d or any other format.
3. Edit date from 'September, 2 2005 00:00:00' to 'February, 12 2016 00:00:00'(or any date) by editing or clicking the calender, and click 'submit' button.
Observed2:
See output of MYGRID.MYDATE array:
'Fri Feb 12 2016 00:00:00 GMT+0900'
4. The value still get D/Y/M format which used to be Y/M/D format.
Observed
If you change the mask from "Y/m/d" to "y/m/d" as follows:
before:
<cfgridcolumn name="myDate" mask="Y/m/d" type="Date">
after:
<cfgridcolumn name="myDate" mask="y/m/d" type="date">
Then you will see the passed value format becomes D/Y/M format from Y/M/D format...
Expected:
A mask pattern should be consistent at:
- the character pattern on the form display
- inputting
- data sending to ColdFusion.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 4159968
External Customer Info:
External Company:
External Customer Name:
External Customer Email:Attachments:
Comments: