On Fri, 7 Jan 2005 09:55:53 -0800, John Munyan <[EMAIL PROTECTED]> wrote: > I am contemplating the idea of creating cfc's which contain stored procedures > to handle the data access for the site.
Separating out your data access is a good idea (although many would argue the pros and cons of stored procedures). > I was wondering if anyone had experience moving their data access into cfcs > using stored procedures, and what their experience was like, what their > motivations were, and how they feel about having done it now. Was it a good > idea, and would they do it again? Any comments greatly appreciated. As far as application structure is concerned, check out the concepts and models sections of the Mach II Development Guide: http://livedocs.macromedia.com/wtg/public/machiidevguide/ As for stored procs and CFCs, I've just built a web service wrapper around a bunch of Oracle stored procedures (which are also used internally by an Oracle-based application we use). The web service will be used by CF apps running elsewhere in the organization. By encapsulating the stored proc API in CFCs it helps decouple the front end and back end systems - we can do various error handling and data mapping operations in the CFC web service layer so that the 'client' app has a nice, clean interface to work with. -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 5 invites to give away! "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189694 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
