flash forms/cfgrid db query timezone diffrence

[none9898]

I have a flash forms app. with a cfgrid and several cfinputs bound to the grid
data that show a query's returned data datetime type ahead by 2 hours. I
trouble shot and trouble shot and found that the since the server is two hours
behind (mountain) and my computer's clock is two hours ahead of the
server(eastern), that the flash form alters the time of the datetime type. If
I return the data from the query in a cfoutput it returns fine. And if I
change my computer clock's timezone to the server's timezone the data in the
flash form returns fine.

My first thought would try to change the timezone settings for everyone who
visits the site with javascript or something. I just want the data that is
returned from the query to be exactly what is stored in the db and then mask to
display the data the way i would like. Is there anything that anyone can
suggest to make the app. available to anyone in any timezone? Thanks in
advance.

[Mike Nimer]

It should be showing the date in the query. Can you send me a simple test
case, with data (queryNew() works great for this).

thanks,
---nimer

"none9898" <webforumsuser@macromedia.com> wrote in message
news:d085ki$hg2$1@forums.macromedia.com...

>I have a flash forms app. with a cfgrid and several cfinputs bound to the
>grid
> data that show a query's returned data datetime type ahead by 2 hours. I
> trouble shot and trouble shot and found that the since the server is two
> hours
> behind (mountain) and my computer's clock is two hours ahead of the
> server(eastern), that the flash form alters the time of the datetime type.
> If
> I return the data from the query in a cfoutput it returns fine. And if I
> change my computer clock's timezone to the server's timezone the data in
> the
> flash form returns fine.
>
> My first thought would try to change the timezone settings for everyone
> who
> visits the site with javascript or something. I just want the data that
> is
> returned from the query to be exactly what is stored in the db and then
> mask to
> display the data the way i would like. Is there anything that anyone can
> suggest to make the app. available to anyone in any timezone? Thanks in
> advance.
>