> 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,
All of that can be true, if you actually bother to do it. That's one of the reasons I prefer stored procedures. But to do this, you have to ensure that you're ONLY using stored procedures, and typically in every application, there's always one query that's difficult to convert to a stored procedure - usually because it contains significant application logic. > ... much more efficient for doing calculations etc... That's true, if you're doing things that can't be done directly within passthrough SQL. But the vast majority of queries, no matter where they're stored, are basic CRUD that would run the same in either place. > 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. Well, honestly, in the environment you're in, you're probably better off using prepared statements. If there's so much resistance from other developers on your team, and there's no DBA trying to lock down database access to the highest degree possible, and you're not going to write any applications in other environments that could use the stored procedures you created, it's probably not worth fighting over. But you should know that those developers are full of crap about stored procedures being an "old way of doing things". Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:317087 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
