I was not basing that on my current situation. 99.9% of all apps anywhere start with one dbms and end with the same. It is nice to be flexible and not care what your persistence mechanism is but for the most part it will never change. There are several studies on this. The reasons vary from already being heavily invested in hardware and software to code that has dependencies on a specific dbms. Google it yourself or if you really care I'll find some for you Jared.
________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jared Rypka-Hauer Sent: Tuesday, January 09, 2007 11:21 AM To: [email protected] Subject: Re: [Reactor for CF] GetWhere with Two OR's That's a really subjective statement. Many apps are meant to be deployed on any number of different servers with any number of different DB backends. So while it's likely that you guys will never convert from your current in-house platform, I might write 3 dozens apps that are meant to be sold and can support at least the big 3 (Oracle, MySQL, and SQL Server). So in that case the number of apps that are changing back ends substantially outweighs the number of in-house apps that will always be on the same platform. There are always worlds beyond worlds that contain people doing things that are the same as what you do and yet are completely different. Laterz, J ------------------------------------------------ Jared C. Rypka-Hauer Continuum Media Group LLC http://www.web-relevant.com Member, Team Macromedia - ColdFusion "That which does not kill me makes me stranger." - Yonah Schmeidler On Jan 9, 2007, at 11:01 AM, Porter, Benjamin L. wrote: The only down side to that is now you lose the database agnostic portion of your code and create unnecessary dependencies on a specific dbms. In reality almost all web apps never change the database they are using. ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Kotek Sent: Tuesday, January 09, 2007 12:33 AM To: [email protected] <mailto:[email protected]> Subject: Re: [Reactor for CF] GetWhere with Two OR's Once you start getting into queries like this, you really have to ask yourself if you should be trying to do this with the OO queries. I'd give some thought to just placing the SQL into a custom gateway method. Just my 2 cents. Brian On 1/2/07, Jon Clausen <[EMAIL PROTECTED]> wrote: Benjamin, Thanks so much for your help - and your feedback. The actual query I had written using reactor does have explicit fields in the select, so I probably should have included those. I'll have to try using a sub-query, though. Very good points! Regards, Jon -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- **************************************************************************** This email may contain confidential material. If you were not an intended recipient, Please notify the sender and delete all copies. We may monitor email to and from our network. **************************************************************************** -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
