> S. Isaac Dealey wrote: >> cfqueryparam can't perform this function, because a sql >> variable can't >> be used as a portion of this query -- without first >> trapping it in >> something within the db like sp_executesql @mystatement >> or >> exec(@mystatement) ... So queryparam doesn't change the >> purpose or >> frequency with which you would use preservesinglequotes() >> at all... >> That being said, I rarely find any need to use >> preservesinglequotes(); >> and you're right the answer to the original question this >> thread >> started with probably lies with cfqueryparam and not >> preservesinglequotes.
> <cfquery> > exec(<cfqueryparam cfsqltype="" value="">) > </cfquery> > Would that be possible? ;-) Could be... ( okay, so cfqueryparam _alone_ can't replace preservesinglequotes() =) ... dunno if I'd ever use it tho... Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
