I do you feel it would defeat the point?

On Thu, Oct 30, 2008 at 2:19 PM, Adrian Lynch <[EMAIL PROTECTED]>wrote:

> 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:314630
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Reply via email to