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 > 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? 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#tz:=#tzName#dst savings:=#dstSavings#in DST:=#tz.inDaylightTime(now())# "); -- 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 > 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? 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#tz:=#tzName#dst savings:=#dstSavings#in DST:=#tz.inDaylightTime(now())# "); -- 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
> 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? 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#tz:=#tzName#dst savings:=#dstSavings#in DST:=#tz.inDaylightTime(now())# ");
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. 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.
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 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. 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 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. 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
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 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. > > dataProvider="{getAlltblreservationResult.lastResult}" visible="false"> > > > > dataField="pkReservationID"/> > > dataField="fkPilotID"/> > > dataField="fkPlaneID"/> > > dataField="szSourceAirport"/> > > dataField="szDestAirport"/> > > dataField="dtStart"/> > > dataField="dtEnd"/> > > dataField="szSpecialRequests"/> > > dataField="pkPilotID"/> > > dataField="szPilotLastName"/> > > dataField="szDescription"/> > > dataField="szPilotFirstName"/> > > > > > > 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@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. 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
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. 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
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