Need a west coast (US) based ColdFusion host

Hey all... I know this topic ("can somebody recommend a CF host") comes up frequently... I hate to bring it up again, but I must :) I have a client that needs to be on shared hosting (they don't have the funds for VPS, unfortunately) on a server with the clock set to PST. They're a company that's physically based in CA... recently moved hosts to an east-coast based company, and now timestamps are off by 3 hours when they add events. According to the previous developer, they're using a calendaring system (specifically, a particular version of a calendaring system) that isn't set up to handle time zone differences.  He's told me that trying to update the code to handle this would "open a whole new can of worms". I've explored the options, and the path of least resistance seems to be to relocate the site to a server based on the west coast.  Or at the very least, a server whose clock is set to PST. A quick google turned up Illuminated Hosting ( http://www.illuminatedhosting.com/), but I'm not familiar with them.  Does anybody know of this company?  Or of any others that have servers set to pacific time? Thanks! Charlie -- Charlie Griefer http://charlie.griefer.com/ I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success.

Charlie, I think Alurium is located on the West Coast, plus they're cheap and you can run CFML (Railo) http://www.alurium.com On Thu, Jul 29, 2010 at 3:09 PM, Charlie Griefer <charlie.griefer@gmail.com> wrote: ----- Excess quoted text cut - see Original Post for more -----

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 (?) Thanks, Charlie On Thu, Jul 29, 2010 at 12:12 PM, Scott Stewart <webmaster@sstwebworks.com>wrote: ----- Excess quoted text cut - see Original Post for more -----

Charlie, I think they are exclusively MySQL... I ported over an implementation of blogCFM and it works fine, Railo's pretty complete as far as tag support goes.. On Thu, Jul 29, 2010 at 3:29 PM, Charlie Griefer <charlie.griefer@gmail.com> wrote: ----- Excess quoted text cut - see Original Post for more -----

Nothing against Railo.  My main project right now is a Railo site (altho we're keeping it CF9 compatible) with a mySQL database.  Works a treat. I just don't know this other site well enough to be able to say, "yeah, let's jump over to Railo and convert your MS SQL database to mySQL" :) There's also a flex-based admin area and I'm not sure how well that would work. At this point in time... probably not something that the client would want to undertake (all of the UAT that would be necessary to ensure that all facets of the site still function properly).  They're a small non-profit and I don't think they have the manpower to even do that, nor do I think they'd want to pay me to take that on. Appreciate the feedback tho.  I'd heard Alurium's name mentioned before. Their prices do look appealing.  Just not a good fit for this particular client right now :\ On Thu, Jul 29, 2010 at 12:40 PM, Scott Stewart <webmaster@sstwebworks.com>wrote: ----- Excess quoted text cut - see Original Post for more -----

Can I throw out a suggestion? Consider a trigger on the database that updates a new record and changes it's timestamp when it's inserted or updated? Then you don't need to migrate. andy Nothing against Railo.  My main project right now is a Railo site (altho we're keeping it CF9 compatible) with a mySQL database.  Works a treat. I just don't know this other site well enough to be able to say, "yeah, let's jump over to Railo and convert your MS SQL database to mySQL" :) There's also a flex-based admin area and I'm not sure how well that would work. At this point in time... probably not something that the client would want to undertake (all of the UAT that would be necessary to ensure that all facets of the site still function properly).  They're a small non-profit and I don't think they have the manpower to even do that, nor do I think they'd want to pay me to take that on. Appreciate the feedback tho.  I'd heard Alurium's name mentioned before. Their prices do look appealing.  Just not a good fit for this particular client right now :\ On Thu, Jul 29, 2010 at 12:40 PM, Scott Stewart <webmaster@sstwebworks.com>wrote: ----- Excess quoted text cut - see Original Post for more ----- that). ----- Excess quoted text cut - see Original Post for more -----

Hey Andy: I ran that past the previous developer and he said he thinks that could work. I'll run it past the client and see if they want to invest the time in me identifying which fields would need the trigger, or if they'd rather just move the site and be done with it :) Thanks for the suggestion. On Thu, Jul 29, 2010 at 12:58 PM, Andy Matthews <lists@commadelimited.com>wrote: ----- Excess quoted text cut - see Original Post for more -----

Awesome. Sometimes it's just a matter of looking at it from a different perspective. andy Hey Andy: I ran that past the previous developer and he said he thinks that could work. I'll run it past the client and see if they want to invest the time in me identifying which fields would need the trigger, or if they'd rather just move the site and be done with it :) Thanks for the suggestion. On Thu, Jul 29, 2010 at 12:58 PM, Andy Matthews <lists@commadelimited.com>wrote: ----- Excess quoted text cut - see Original Post for more ----- treat. ----- Excess quoted text cut - see Original Post for more ----- PST. ----- Excess quoted text cut - see Original Post for more -----

No problem, I just moved my blog over there.. I was at Daily Razor, but their prices *ahem* mysterious increased substantially On Thu, Jul 29, 2010 at 3:52 PM, Charlie Griefer <charlie.griefer@gmail.com> wrote: ----- Excess quoted text cut - see Original Post for more -----

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 <charlie.griefer@gmail.com> 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 (

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 <mamamaureen@gmail.com> wrote: ----- Excess quoted text cut - see Original Post for more -----

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 <charlie.griefer@gmail.com ----- Excess quoted text cut - see Original Post for more -----

Check out businessgrade.com.  I used to work there and they keep servers set to all USA timezones. They are not a bargain host but under shared hosting they greatly limit the number of sites they put on a server. They can also get you v.p.s. in different time zones. Ask for Eric and tell him I sent you On Jul 29, 2010 10:16 PM, "Mike Kear" <afpwebworks@gmail.com> wrote: > > I would have thought most hosting companies would have their servers set to ----- Excess quoted text cut - see Original Post for more ----- charlie.griefer@gmail.com >> wrote: > >> >> I -think- it's 2k8, but based on my discussion with the previous developer, ----- Excess quoted text cut - see Original Post for more ----- that). ----- Excess quoted text cut - see Original Post for more -----

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 <afpwebworks@gmail.com> wrote: ----- Excess quoted text cut - see Original Post for more -----

Now() + 3 shouldn't be that hard to implement.  ;)   (assuming all of the date/time stamps are being entered via CFML instead of the DB itself) Just a note, Railo allows you specify the time zone for each site, so if you want to use a Railo host, it doesn't matter where they're physically located.  Your site can have it's own time zone independent of the server time zone. (again, assuming all of the date/time stamps are being entered via CFML instead of the DB itself) Thanks, Eric Cobb ECAR Technologies, LLC http://www.ecartech.com http://www.cfgears.com Charlie Griefer wrote: ----- Excess quoted text cut - see Original Post for more -----

You'd think, right? :) I haven't even looked at the code yet.  Just came onto this project last nite.  But the previous developer is a friend and I trust what he says.  He wrote the current site, and he told me in no uncertain terms that the time zone issue would not be even remotely easy to remedy via code. I don't know why, exactly, but I trust what I've been told. At some point I'm sure I'll dig into the code and find out.  But for now, it looks like moving hosts will be the path of least resistance. On Thu, Jul 29, 2010 at 12:26 PM, Eric Cobb <cftalk@ecartech.com> wrote: ----- Excess quoted text cut - see Original Post for more -----

Charlie, If the code can run on Railo, we have shared servers in our LA data center. But then again if the code can run in Railo you could set the time zone for each virtual host separately. ;-) -- Peter Amiri Founder | Alurium Hosting 949-338-3862 | peter@alurium.com | http://www.alurium.com LinkedIn: http://www.linkedin.com/in/peteramiri | IM bpamiri (AIM/MSN/Y!/GTLK/SKYPE) On Jul 29, 2010, at 12:09 PM, Charlie Griefer wrote: ----- Excess quoted text cut - see Original Post for more -----