What if you first grab the value being returned by the method to a variable, and then feed that variable to your cfqueryparam?
<cfset variables.thisHereVar = arguments.iBean.getHistory() /> <cfquery ...> ... ...<cfqueryparam value="#preservesinglequotes(variables.thisHereVar)#" .... /> </cfquery> > I'm having an issue with using a queryparam on a CLOB column in Oracle. > I am using queryparam, but when I insert or update it throws an error > when I pass in a string of text that looks like this including all > quotes "this is a person's test" I can't use Preservesinglequotes > because the text is coming from an object that looks like this > arguments.iBean.getHistory() when I try to use Preservesinglequotes it > throws an error. Any ideas? > > Bob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228385 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
