Interesting and odd...
The actual item that I'm receiving is one hour in advance over the time that is logged in the MySQL DB. I just verified for a 3rd time that everything is set correctly in my Coldfusion9 server. Perhaps this is a third bug that I just found with accessing a CF data source...? I'm going to run a few more tests here to ensure it's not my issue then submit another bug report if everything checks out. I'm going to run this by another CF developer and see what he thinks. I should also write a .CFM to test the function to ensure that coldfusion is providing the correct information. Thanks, Tracy. You rock. sj ________________________________ From: flexcoders@yahoogroups.com [mailto:flexcod...@yahoogroups.com] On Behalf Of Tracy Spratt Sent: Sunday, June 27, 2010 7:01 PM To: flexcoders@yahoogroups.com Subject: RE: [flexcoders] Working with date/Time in FB Instead of binding, use a result handler and inspect the actual xml. Have you set resultFormat="e4x"? Tracy Spratt, Lariat Services, development services available ________________________________ From: flexcoders@yahoogroups.com [mailto:flexcod...@yahoogroups.com] On Behalf Of Scott Sent: Sunday, June 27, 2010 4:27 PM To: flexcoders@yahoogroups.com Subject: RE: [flexcoders] Working with date/Time in FB I just verified both server and client are at the same time and same timezone. I wasn't doing anything special with the object I was returning initially when it was giving me the wrong time. I literally assigned the dataGrid to the CFobject that was being passed. <mx:DataGrid x="68" y="446" id="dataGrid" dataProvider="{getAlltblreservationResult.lastResult}" visible="false"> <mx:columns> <mx:DataGridColumn headerText="pkReservationID" dataField="pkReservationID"/> <mx:DataGridColumn headerText="fkPilotID" dataField="fkPilotID"/> <mx:DataGridColumn headerText="fkPlaneID" dataField="fkPlaneID"/> <mx:DataGridColumn headerText="szSourceAirport" dataField="szSourceAirport"/> <mx:DataGridColumn headerText="szDestAirport" dataField="szDestAirport"/> <mx:DataGridColumn headerText="dtStart" dataField="dtStart"/> <mx:DataGridColumn headerText="dtEnd" dataField="dtEnd"/> <mx:DataGridColumn headerText="szSpecialRequests" dataField="szSpecialRequests"/> <mx:DataGridColumn headerText="pkPilotID" dataField="pkPilotID"/> <mx:DataGridColumn headerText="szPilotLastName" dataField="szPilotLastName"/> <mx:DataGridColumn headerText="szDescription" dataField="szDescription"/> <mx:DataGridColumn headerText="szPilotFirstName" dataField="szPilotFirstName"/> </mx:columns> </mx:DataGrid> Both dtStart and dtEnd were exactly one hour ahead of where they should be when I made the CF call. ________________________________ From: flexcoders@yahoogroups.com [mailto:flexcod...@yahoogroups.com] On Behalf Of Smin Rana Sent: Sunday, June 27, 2010 7:30 AM To: flexcoders@yahoogroups.com Subject: RE: [flexcoders] Working with date/Time in FB Are you sure server and FB got same timezone? I think you got some problem with your manipulation of before you set it to datagrid can you show the code where you set date on datagrid? Response date as a string from cf and set it on datagrid without any formatting? -----Original Message----- From: Scott Sent: 06-27-2010 19:19:40 Subject: [flexcoders] Working with date/Time in FB There's something I'm not completely understanding yet. I've coded around it but I'm not feeling comfortable with my solution. My FB4 app links up with CF9 and I'm working with dates and times. When I pull up a date from CF9 into a FB4 datagrid the time shows off by one hour. Eg. 2010-06-01 23:30:00 is in my MySQL DB (11:30pm). When I load the time from CF9 to a FB4 dataGrid it shows 2010-06-02 as the date and 12:30:00 as the time so the day advances because the time is one hour ahead. My initial thought is that it's something to do with either the timezone or day light savings time. Right now I just set a variable that I call DST, set it to -1 and then subtract it from the date before I manipulate the date and time. Even getting the UTC date/time then using the timezone still gets it off one hour without accounting for DST (that's why I think I'm dealing with daylight savings time) Can anyone confirm this or shed any light on what is going on? I don't want FB to worry about date and time; I want to do all of this through CF9 on the server side. I don't want to worry if the user has their computer set correctly for their timezone and daylight savings time. I just want FB to display the time it pulls directly from the CF9 object I provide it. Thanks a ton. sj -- This message has been scanned for viruses and dangerous content by MailScanner <http://www.mailscanner.info/> , and is believed to be clean. -- This message has been scanned for viruses and dangerous content by MailScanner <http://www.mailscanner.info/> , and is believed to be clean.
