We are wrapping up with this great charting application at cfwebtools, and we get a call from a customer that says our data is wrong….
We listen to them, and debug, and for some reason we just can’t quite see the same thing he see’s… On top of that, no one else is having the problem, but the fact is that, he has showed us screen shots, he’s duplicated on Four pc’s of his own, and he’s talked to 10 friends telling us that our data is wrong, and that there is mismatched days in our chart.
When he was bringing up the charting application, the charts showed up successfully, but when you ta
ke a closer look, and you know your stuff about Financial Charting applications, you know what your looking for, and you know it with GREAT detail. So this guy, tells us our data is wrong, and pretty much with all of his friends proved to us SOMETHING was going wrong, but we couldn’t duplicate it.
The data is not that complicated, it looks like this:
but on his computer it looked like this:
EVERYTHING WAS SLID BACK BY ONE DAY.
the Date/Time objects were coming back from coldfusion, and it was returning coldfusion sql. They looked like this:
what was really happening is that, flash auto adjusts for your Timezone… so what was really happening is the data is getting turned into this in flash (if they come back to flash as date/time objects)
Pacific Standard Time
I’m sort of at a loss and i’m looking for help, there is one post that was more clear than the rest, but still doesnt solve my issue, it’s written by Ted Patrick of adobe. He states to use Universal Time, (UTC).
I have a problem with this!
I’m not the one creating the date times, nor do I get a chance to touch the data before it goes to my components… Of course I could obviously go in, to my result function of my remote object, or my command of cairngorm, and loop over the data, and adjust it all manually… BUT NOOOOO, I Don’t want to, what if i’m dealing with 40,000 records in a charting application (how bout we make it an even MILLION records, just to prove a point), then obviously the flash player has enough work to do on it’s own, without me looping through the data.
How do I query my database, and have it be a 00:00:00 time, and not have flash offset my date when it comes back to it?
For now, we manually change things in our query to add hours to the date time, but that is kind of sloppy…
Please check the example, and help me out if you can… Like I said I’m at a loss with this one.