This is a strange one.
I have a website that displays event data pulled from MSSQL 2005 via
ColdFusion 8 and then is rendered in an AS3 flash application via a remoting
call. I use a CFC to create an Array to pass data to the flash application.
Here's the weird part. It doesn't seem to matter which browser or version of
the flash player you are using but one user will be provided a list of events
with the correct start and end date, and then another person on a different PC
will get the same event information but with different dates, one day less
exactly???? Keep in mind these machines have identical configurations.
I do not understand how this could be happening.
The MSSSQL 2005 field is a datetime field. But this still does not explain
that the dates drop one day.
Any assistance here would be great.
sportsmanswarehouse - 03 Sep 2008 22:02 GMT
I figured this out myself.
do not use for example: startDate.date
use:
startDate.dateUTC
This is because AS3 date function like to interpret the time zone. News to me.