[CLOSED] [1.0] jsonStore.loadData(json) is not changing date string into object inside IE 8

hi,

please fix this bug in the bad IE 8

Code:

createJsonStoreFromJsonResults = function(json) { /* prepare results for reader */ var flds = []; $.each(json, function(n, v) { var recordField = { 'name': n } if (n != undefined && (n + "").toLowerCase().indexOf('date') > -1) { recordField['type'] = 'date'; } flds.push(recordField); }); /* process results and convert them to bindable format */ var store = new Ext.data.JsonStore({ idProperty: flds[0].name, fields: flds }); /* load json data into store */ store.loadData(json,true); return store; }

the above js function work fine in firefox but not in the IE... please test it and fix it.

bye and thanks,

Hi,

Please provide full test sample and describe the problem in details

Vladimir... this what you asked for!!

Code:

<%@ Page Language="C#" %> <%@ Import Namespace="System.Data" %> <%@ Register Assembly="Ext.Net" Namespace="Ext.Net" TagPrefix="ext" %> <html xmlns="http://www.w3.org/1999/xhtml"> <head id="Head1" runat="server"> <title>Ext.NET Example</title> <script src="Scripts/jquery-1.4.2.js" type="text/javascript"></script> <script runat="server"> [DirectMethod] public static DataTable GetScheduleInformation(long schNo) { DataTable table = new DataTable(); table.Columns.Add("proposalDate", typeof(DateTime)); table.Rows.Add(DateTime.Now); return table; } </script> <script type="text/javascript"> createJsonStoreFromJsonResults = function(json) { /* prepare results for reader */ var flds = []; $.each(json, function(n, v) { var recordField = { 'name': n } if (n != undefined && (n + "").toLowerCase().indexOf('date') > -1) { recordField['type'] = 'date'; } flds.push(recordField); }); /* process results and convert them to bindable format */ var store = new Ext.data.JsonStore({ idProperty: flds[0].name, fields: flds }); /* load json data into store */ store.loadData(json, true); return store; } loadFormControls = function(sId) { Ext.net.DirectMethods.GetScheduleInformation(sId, { success: function(result) { if (result[0].json == undefined) { result[0] = createJsonStoreFromJsonResults(result[0]).getRange(0, 0)[0]; } Ext.getCmp('fp1').getForm().loadRecord(result[0]); }, failure: function(result) { alert(result); } }); } </script> </head> <body> <ext:ResourceManager ID="ResourceManager1" runat="server" /> <ext:FormPanel runat="server" ID="fp1"> <Items> <ext:Button runat="server" ID="btnLoad" Text="Bind"> <Listeners> <Click Handler="loadFormControls(5);" /> </Listeners> </ext:Button> <ext:DateField runat="server" ID="dtProposalDate" FieldLabel="Proposal Date" DataIndex="proposalDate" AnchorHorizontal="95%" Disabled="true" Format="dd/MM/yyyy" /> </Items> </ext:FormPanel> </body> </html>

the above code work fine on FireFox but not in IE...

i made deep debugging and found that IE stuck at [Date.parse] inside convert() while firefox did the parse correctly.

stack:
convert();
extractValues();
extractData();
readRecords();
loadData();

this should save you time in solving the issue.

also these two stackoverflow links showing that IE fails to parse some formats:
http://stackoverflow.com/questions/3...-parsing-error
http://stackoverflow.com/questions/2...-a-date-object

thanks

Hi,

You have to define date format 'recordField['dateFormat'] = 'Y-m-dTh:i:s';'

Code:

<%@ Page Language="C#" %> <%@ Import Namespace="System.Data" %> <%@ Register Assembly="Ext.Net" Namespace="Ext.Net" TagPrefix="ext" %> <html xmlns="http://www.w3.org/1999/xhtml"> <head id="Head1" runat="server"> <title>Ext.NET Example</title> <script src="http://ajax.microsoft.com/ajax/jQuery/jquery-1.4.2.js" type="text/javascript"></script> <script runat="server"> [DirectMethod] public static DataTable GetScheduleInformation(long schNo) { DataTable table = new DataTable(); table.Columns.Add("proposalDate", typeof(DateTime)); table.Rows.Add(DateTime.Now); return table; } </script> <script type="text/javascript"> createJsonStoreFromJsonResults = function(json) { /* prepare results for reader */ var flds = []; $.each(json, function(n, v) { var recordField = { 'name': n } if (n != undefined && (n + "").toLowerCase().indexOf('date') > -1) { recordField['type'] = 'date'; recordField['dateFormat'] = 'Y-m-dTh:i:s'; } flds.push(recordField); }); /* process results and convert them to bindable format */ var store = new Ext.data.JsonStore({ idProperty: flds[0].name, fields: flds }); /* load json data into store */ store.loadData(json, true); return store; } loadFormControls = function(sId) { Ext.net.DirectMethods.GetScheduleInformation(sId, { success: function(result) { if (result[0].json == undefined) { result[0] = createJsonStoreFromJsonResults(result[0]).getRange(0, 0)[0]; } Ext.getCmp('fp1').getForm().loadRecord(result[0]); }, failure: function(result) { alert(result); } }); } </script> </head> <body> <ext:ResourceManager ID="ResourceManager1" runat="server" /> <ext:FormPanel runat="server" ID="fp1"> <Items> <ext:Button runat="server" ID="btnLoad" Text="Bind"> <Listeners> <Click Handler="loadFormControls(5);" /> </Listeners> </ext:Button> <ext:DateField runat="server" ID="dtProposalDate" FieldLabel="Proposal Date" DataIndex="proposalDate" AnchorHorizontal="95%" Disabled="true" Format="dd/MM/yyyy" /> </Items> </ext:FormPanel> </body> </html>

Also, your sample can be simplified to the following one (please note that I set AltFormats for the date field)

Code:

<%@ Page Language="C#" %> <%@ Import Namespace="System.Data" %> <%@ Register Assembly="Ext.Net" Namespace="Ext.Net" TagPrefix="ext" %> <html xmlns="http://www.w3.org/1999/xhtml"> <head id="Head1" runat="server"> <title>Ext.NET Example</title> <script src="http://ajax.microsoft.com/ajax/jQuery/jquery-1.4.2.js" type="text/javascript"></script> <script runat="server"> [DirectMethod] public static object GetScheduleInformation(long schNo) { return new { proposalDate = DateTime.Now }; } </script> <script type="text/javascript"> loadFormControls = function(sId) { Ext.net.DirectMethods.GetScheduleInformation(sId, { success: function(result) { fp1.getForm().setValues(result); }, failure: function(result) { alert(result); } }); } </script> </head> <body> <ext:ResourceManager ID="ResourceManager1" runat="server" /> <ext:FormPanel runat="server" ID="fp1"> <Items> <ext:Button runat="server" ID="btnLoad" Text="Bind"> <Listeners> <Click Handler="loadFormControls(5);" /> </Listeners> </ext:Button> <ext:DateField runat="server" ID="dtProposalDate" FieldLabel="Proposal Date" DataIndex="proposalDate" AnchorHorizontal="95%" Disabled="true" Format="dd/MM/yyyy" AltFormats="Y-m-dTh:i:s" /> </Items> </ext:FormPanel> </body> </html>

thank you very much...you the man!

regarding the simplified code it's not gonna help me because this was only the test case but all DB objects returned as DataTables in my projects....anyway thanks for that!!

please mark as solved!