Ok, you proved you're smart when it comes to deep OO stuff. ;) But really, would your boss be sympathetic if you told him it took you 4 hours to get the data you need out of a db because you 'need' to do it properly, when he knows you could do it in less than an hour? And I don't agree that you will ever need to do that particular query again in a different app. If it were possible, why would we all need to know SQL? Why couldn't you just by a pre-canned database that did everything for you? Because you always have to write queries to solve business logic, and you can rarely take a complex query and plug it into a different app. I am /not/ saying that you should do it procedurally. OO is like normalizing a DB. You could go out the 5 or 6th level, but the experts agree that you never should, because the benefit of full normalization is outweighed by the cost it creates when you decide you actually need to use this database.
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Barney Boisvert > Sent: Thursday, August 18, 2005 11:32 AM > To: [email protected] > Subject: Re: [CFCDev] Better way than dao, gateway, bean: <cfquery> > > Valid points, to be sure, but in that scenario, I'd have exactly what > you described as the 'right' solution. The only difference would be > that the CFC method would live in a gateway, along with other methods. > The purpose of gateways is to simply provide an OO interface to a > SELECT statement, nothing more. All the other stuff is for dealing > with entity persistance operations (i.e. a single customer, or a > single user). > > There's a place for both in pretty much every application, and having > defined gateways makes sure all your SELECT statements reside > together, so they're easy to update if your schema changes. > > cheers, > barneyb This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). CFCDev is supported by New Atlanta, makers of BlueDragon http://www.newatlanta.com/products/bluedragon/index.cfm An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
