Mike: The current host has severs on east coast time as well as GMT. Unfortunately, the app is architected in such a way that it can't handle timezone offsets, whether it's east coast or GMT... it expects that the time entered is going to be the time displayed :\
On Thu, Jul 29, 2010 at 7:16 PM, Mike Kear <[email protected]> wrote: > > I would have thought most hosting companies would have their servers set to > UTC ( or Greenwich Mean Time) . Is that not true? > > I have servers in California, but ours are on UTC so we can move them from > place to place if we choose and it makes no difference to the code. > > > Cheers > Mike Kear > Windsor, NSW, Australia > Adobe Certified Advanced ColdFusion Developer > AFP Webworks > http://afpwebworks.com > ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month > > > > > On Fri, Jul 30, 2010 at 12:02 PM, Charlie Griefer < > [email protected] > > wrote: > > > > > I -think- it's 2k8, but based on my discussion with the previous > developer, > > I'm not sure database tweaks are going to do it. > > > > I've pitched Andy's trigger idea to the client. Still waiting to hear > > back... > > > > On Thu, Jul 29, 2010 at 6:55 PM, Maureen <[email protected]> wrote: > > > > > > > > Which version of SQL Server, because timezone data is handled > > > differently between 2005 and 2008, and if it is 2008 you could likely > > > fix this issue with some database tweeks. > > > > > > On Thu, Jul 29, 2010 at 12:29 PM, Charlie Griefer > > > <[email protected]> wrote: > > > > > > > > Hey Scott: > > > > > > > > Hmm... not sure that the current site will run under Railo. Also, > > their > > > > current database is SQL Server (I probably should have mentioned > that). > > > > Looks like Alurium is exclusively Railo/mySQL ( > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335881 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
