Exactly, which kinda defeats the point I feel. I've got a few ways that I might try but for now I'm back to writing SPs.
If anyone's interested, I have the full DAO code here: http://adrianlynch.co.uk/post.cfm?postID=21 Adrian Building a database of ColdFusion errors at http://cferror.org/ -----Original Message----- From: [EMAIL PROTECTED] Sent: 30 October 2008 18:28 To: cf-talk Subject: RE: cfqueryparam vs cfstoredproc? exec() or sp_executesql You would need to pass in the arguments as a list to the procedure and then do the looping and building of a dynamic query with SQL. Then execute what you have created. Good luck. Dynamic SQL isn't nearly as easy in SQL than CF. Also, you will have to take additional steps to paramaterize it. (requires sp_executesql) FYI: My advice assumes MS SQL. ~Brad -------- Original Message -------- Subject: RE: cfqueryparam vs cfstoredproc? From: "Adrian Lynch" <[EMAIL PROTECTED]> Date: Thu, October 30, 2008 1:06 pm To: cf-talk <cf-talk@houseoffusion.com> An open question then... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:314629 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4