> > 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:296285 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
