You are getting data as xml from cf, so everthing should be fine.
if you return A you should get A.
now it looks like thing is very interesting, cant you help you in this case,
again debug the code and take a look of the network monitor
Of FB.
-----Original Message-----
From: Scott
Sent: 06-28-2010 03:27:00
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.
