Object-Relational Mapping, actually. Transfer seems to have the most traction nowadays.
On Jan 9, 2008 1:17 PM, Dominic Watson <[EMAIL PROTECTED]> wrote: > > > > Use an ORM > > > ORM = Object-Relational Modeler/Modeling > Examples: > > * Reactor: > > http://www.alagad.com/go/products-and-projects/reactor-for-coldfusion/reactor-for-coldfusion > * Transfer: http://compoundtheory.com/?action=transfer.index > > In a nutshell, these work by automatically generating components for you > that give you an interface with your database entities. With Reactor, you > setup an xml config file that tells it what datasource to use and also > tells > it what entities you want it to automate. Then, in your application, you > create an instance of the reactor factory component passing it this config > file. You can then do things like this: > > <!--- get a query of all users in the user table ---> > <cfset users = reactorFactory.createGateway("users").GetAll()> > > <!--- delete a user ---> > <cfset user = reactorFactory.createRecord("users")> > <cfset user.Load(userID=url.userID)> > <cfif user.delete()>....</cfif> > > This is just scratching the surface :) > > Dominic > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296287 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

