Awesome. Sometimes it's just a matter of looking at it from a different perspective.
andy -----Original Message----- From: Charlie Griefer [mailto:[email protected]] Sent: Thursday, July 29, 2010 3:34 PM To: cf-talk Subject: Re: Need a west coast (US) based CF host 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 <[email protected]>wrote: > > 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 > > -----Original Message----- > From: Charlie Griefer [mailto:[email protected]] > Sent: Thursday, July 29, 2010 2:52 PM > To: cf-talk > Subject: Re: Need a west coast (US) based CF host > > > 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 > <[email protected]>wrote: > > > > > 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 > > <[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 (?) > > > > > > Thanks, > > > Charlie > > > > > > On Thu, Jul 29, 2010 at 12:12 PM, Scott Stewart > > > <[email protected]>wrote: > > > > > >> > > >> 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 > > >> <[email protected]> wrote: > > >> > > > >> > 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. > > >> > > > >> > > > >> > > > >> > > >> > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:335873 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
