RE: [flexcoders] Working with date/Time in FB
Thanks for your help everyone. I found the issue and it's fixed. The
JVM has a bug in it and required upgrading it on the server. Now if I
can stop getting these silly timewasting bugs I can finish my project!
=)
Thanks a ton!
From: flexcoders@yahoogroups.com [mailto:flexcod...@yahoogroups.com] On
Behalf Of Scott
Sent: Monday, June 28, 2010 6:41 AM
To: flexcoders@yahoogroups.com
Subject: RE: [flexcoders] Working with date/Time in FB
I am using remoteobject.
The following code returns the same timezone information as my
workstation is in.
From: flexcoders@yahoogroups.com [mailto:flexcod...@yahoogroups.com] On
Behalf Of Paul Hastings
Sent: Sunday, June 27, 2010 10:59 PM
To: flexcoders@yahoogroups.com
Subject: Re: [flexcoders] Working with date/Time in FB
mx:DataGrid x= 68 y= 446 id= dataGrid dataProvider= {
getAlltblreservationResult.lastResult } visible= false
uh, are you using a web service instead of remote object?
how did you confirm your cf server's in the same tz as your w/s? it's
possible
that the OS JVM that cf's running under are using different tz. what
dos the
following snippet tell you?
cfscript
jre=createObject(java,java.lang.System);
JREname=jre.getProperty(java.runtime.name);
JREversion=jre.getProperty(java.runtime.version);
tz=createObject(java,java.util.TimeZone).getDefault();
tzName=tz.getDisplayName(true,tz.LONG);
dstSavings=tz.getDSTSavings()/360;
writeoutput(jre:=#JREname# #JREversion#brtz:=#tzName#brdst
savings:=#dstSavings#brin DST:=#tz.inDaylightTime(now())# );
/cfscript
--
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.
RE: [flexcoders] Working with date/Time in FB
I am using remoteobject.
The following code returns the same timezone information as my
workstation is in.
From: flexcoders@yahoogroups.com [mailto:flexcod...@yahoogroups.com] On
Behalf Of Paul Hastings
Sent: Sunday, June 27, 2010 10:59 PM
To: flexcoders@yahoogroups.com
Subject: Re: [flexcoders] Working with date/Time in FB
mx:DataGrid x= 68 y= 446 id= dataGrid dataProvider= {
getAlltblreservationResult.lastResult } visible= false
uh, are you using a web service instead of remote object?
how did you confirm your cf server's in the same tz as your w/s? it's
possible
that the OS JVM that cf's running under are using different tz. what
dos the
following snippet tell you?
cfscript
jre=createObject(java,java.lang.System);
JREname=jre.getProperty(java.runtime.name);
JREversion=jre.getProperty(java.runtime.version);
tz=createObject(java,java.util.TimeZone).getDefault();
tzName=tz.getDisplayName(true,tz.LONG);
dstSavings=tz.getDSTSavings()/360;
writeoutput(jre:=#JREname# #JREversion#brtz:=#tzName#brdst
savings:=#dstSavings#brin DST:=#tz.inDaylightTime(now())# );
/cfscript
--
This message has been scanned for viruses and
dangerous content by MailScanner http://www.mailscanner.info/ , and is
believed to be clean.
[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
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
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.
RE: [flexcoders] Working with date/Time in FB
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.
Re: [flexcoders] Working with date/Time in FB
What is timezone value at the client? If you are at one of the region
On Windows XP the behavior can be reproduced with:
Beirut (Lebanon)
Brasilia (Brasil)
Buenos Aires (Argentina)
Amman (Jordany)
Cairo (Egypt)
Manaus (Brasil)
Santiago (Chile)
then wait for the winter for DST time to be gone =)
*Flash Player https://bugs.adobe.com/jira/browse/FP*
Date class Bug
https://bugs.adobe.com/jira/browse/FP-1760
https://bugs.adobe.com/jira/browse/FP-1760
--
Best regards,
Andriy Panas
On 27 June 2010 23:22, Smin Rana sminr...@gmail.com wrote:
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 flexcoders%40yahoogroups.com [mailto:
flexcoders@yahoogroups.com flexcoders%40yahoogroups.com] On
Behalf Of Smin Rana
Sent: Sunday, June 27, 2010 7:30 AM
To: flexcoders@yahoogroups.com flexcoders%40yahoogroups.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.
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 http://www.mailscanner.info/ MailScanner, and is
believed to be clean.
RE: [flexcoders] Working with date/Time in FB
Both the server and workstation are in the CST timezone/North America.
From: flexcoders@yahoogroups.com [mailto:flexcod...@yahoogroups.com] On
Behalf Of Andriy Panas
Sent: Sunday, June 27, 2010 3:43 PM
To: flexcoders@yahoogroups.com
Subject: Re: [flexcoders] Working with date/Time in FB
What is timezone value at the client? If you are at one of the region
On Windows XP the behavior can be reproduced with:
Beirut (Lebanon)
Brasilia (Brasil)
Buenos Aires (Argentina)
Amman (Jordany)
Cairo (Egypt)
Manaus (Brasil)
Santiago (Chile)
then wait for the winter for DST time to be gone =)
Flash Player https://bugs.adobe.com/jira/browse/FP
https://bugs.adobe.com/jira/images/icons/link_out_bot.gif Date class
Bug
https://bugs.adobe.com/jira/browse/FP-1760
https://bugs.adobe.com/jira/browse/FP-1760
https://bugs.adobe.com/jira/browse/FP-1760
--
Best regards,
Andriy Panas
On 27 June 2010 23:22, Smin Rana sminr...@gmail.com
mailto:sminr...@gmail.com wrote:
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:flexcoders%40yahoogroups.com
[mailto:flexcoders@yahoogroups.com mailto:flexcoders%40yahoogroups.com
] On
Behalf Of Smin Rana
Sent: Sunday, June 27, 2010 7:30 AM
To: flexcoders@yahoogroups.com mailto:flexcoders%40yahoogroups.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/
http://www.mailscanner.info/ , and is
believed to be clean.
--
This message has been scanned for viruses
RE: [flexcoders] Working with date/Time in FB
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
Re: [flexcoders] Working with date/Time in FB
mx:DataGrid x= 68 y= 446 id= dataGrid dataProvider= {
getAlltblreservationResult.lastResult } visible= false
uh, are you using a web service instead of remote object?
how did you confirm your cf server's in the same tz as your w/s? it's possible
that the OS JVM that cf's running under are using different tz. what dos the
following snippet tell you?
cfscript
jre=createObject(java,java.lang.System);
JREname=jre.getProperty(java.runtime.name);
JREversion=jre.getProperty(java.runtime.version);
tz=createObject(java,java.util.TimeZone).getDefault();
tzName=tz.getDisplayName(true,tz.LONG);
dstSavings=tz.getDSTSavings()/360;
writeoutput(jre:=#JREname# #JREversion#brtz:=#tzName#brdst
savings:=#dstSavings#brin DST:=#tz.inDaylightTime(now())# );
/cfscript
