I think maybe it was the calls to the procs, I would doubt they would store sps in a cfc themselves!
"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Phillip Holmes To: CF-Talk Sent: Wed Oct 25 02:36:17 2006 Subject: RE: All Stored Procs in 1 CFC? All stored procs in one cfc? IMHO, that pretty ham-handed. CodeSmith generates a data layer (.NET) that is pretty spiffy and cfcpowertools (http://cfcpowertools.com/) does an awesome job at genning damn near the entire backend. Warmest Regards, Phillip B. Holmes http://phillipholmes.com -----Original Message----- From: Jeff Fleitz [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 24, 2006 8:23 PM To: CF-Talk Subject: Re: All Stored Procs in 1 CFC? If you are using Windows and SQL Server, Plum will do this for you. The IDE (code gen) contains options for generating CRUD SPs per table and will also generate a CFC that calls them. I haven't been using SPs as of late, but it worked well with MS SQL 2000. I would think they would work with MS SQL 2005, but can't say for sure. http://www.productivityenhancement.com/plum/ HTH On 10/24/06, Brian Peddle <[EMAIL PROTECTED]> wrote: > > I have worked a few companies where they use .NET and know of several > other companies who follow this process. They have a generator that > reads all the stored procs and creates the needed code in .NET to make > the calls to the stored procedures in classes. All this is done > automatically and the file is never edited by human hands. One of the > cool things is that if a stored proc is altered and the file is > recreated on build any page calling that class will fail and they can > quickly and easily see what needs to be fixed. The other cool thing > is all the SQL is in one place. > > Anyway, has anyone ever done this in CF? Not so much the auto > generate stuff (although be good to know) but have one monster .cfc > with all the calls. Since it isn't compiled like .NET performance may > be a huge issue but not sure. Or maybe if this is tossed in > application scope it would fly. > > Thoughts? > > Hope this made sense. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257966 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
