You can do what you are looking for with cfcPowerTools. It will generate a DAO CFC with basic CRUD functions. You can then extend that CFC to add customizations as needed.
cfcPowerTools' purpose is to quickly get your development efforts under way allowing you to focus on solving business problems. It frees you up from doing the same type of code over and over again. Tom -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, August 18, 2005 12:28 PM To: [email protected] Subject: RE: [CFCDev] Better way than dao, gateway, bean: <cfquery> Jacob, I totally agree. I think most of this stuff goes too far. I started into CFCs with a quest to make life as simple as possible. I've found what I wanted, but it isn't with the Gateway/DAO/Bean method of doing things. I love CFCs, and they save me tons of time and give my apps lots of power for just a little coding time. I do like OO development, and use OO when appropriate in my apps (particularly for caching user and system data in memory), but I've always hated the DAO world and all things thereof. My ideal data access CFC will automatically create common functions (CRUD, etc), and then allow me to override or modify behavior as needed. Long answer, but I totally agree with you. -Sam Curren --- [email protected] wrote: Has anybody ever used <cfquery>? Ok, I'm being very sarcastic, but bear > with me. I know I'm about to start a flame war, with the two teams > being all 2000 of you against me. :) > > Here's a scenario: > -My client wants me to return data with some edge case business logic, > nobody else I work for wants this logic in my app > -I need to join 5 tables using fairly complex conditions > -I then need to use the data from this query in a number of cfms > > Solution 1: > > 1. I build all of the gateway/dao/bean/jar/dll/exe/ini/etc I need > to access and join the 5 tables > 2. I then build all the cfcs and cfms that will be required to init > and expose the 35 objects I created in step 1 > 3. I invoke the files created in step 2 to put the data on the > screen > 4. Total time: 6 days and 1 day of rest > > Solution 2: > > 1. I build 1 <cfquery> that lives in a cfc. > 2. I invoke the cfc on all of the necessary pages > 3. Total time: 1 or 2 hours > > Please excuse my lame attempts at dry humor up there. :] I admit I > don't understand most of the stuff you guys bicker about on this list, > beyond creating and invoking objects. But does at least one person here > agree with me that it is possible to take OO too far? OO is a very > important concept, but like everything else in this world, I think it > can be over done. > > 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] > > > > ---------------------------------------------------------- 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] ---------------------------------------------------------- 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]
