I will also add that there is a not insignificant movement toward using ORMs for the database access layer. In that model, most all of the sql is abstracted out for you and when you do write sql, it's using a language specific to the ORM. We've got some .net guys at my office who are using NHiberbate and I've used Transfer a bit. I still prefer to hand-write my queries but there can certainly be some advantages to using an ORM including cacheing, database independency and a closer match between your business objects and your code.
Judah On Mon, Dec 22, 2008 at 12:19 PM, Matthew Allen <[email protected]> wrote: > Thanks Ian and Dave, it was my guess that these guys were just been really > stubborn, though more experienced than myself, it seems they are set in their > ways. > > My understanding of SQL/Oracle Dbases is that you can use them to create > extra layers of security, like for example restricting user-level access to > objects within the database itself, much more efficient for doing > calculations etc...these guys just believes that stored proc is an old way of > doing things and that I should get stored proc out of my head...they believe > cfqueryparam is the solution to all problems. > > I was starting to think I was going mad, especially when you have 5 against 1 > (myself):-).. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317090 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
