This content has been marked as final. Show 3 replies
1. please post your code
2.what is the error message?
3. Are you using cfqueryparam and/or cfprocparam in your database access code? If not you should be.
A quick answer is to use a RegEx to strip invalid characters from the input stream.
... or use XmlFormat - which doesn't necessarily have to be used for XML - which converts such characters into web service-readable form.
Thank you for your replies and help, appreciate it.
I will try cfqueryparam and Xmlformat and see it that will solve the problem. I'll try both in the insert statement.
My code goes like this: putting parts of the code only...
<cfinvoke webservice ="mywebservice_url"
<cfinvokeargument name="description" value="#ReReplace(form.description,'[^[:print:]]','','ALL')#"/>
<cffunction name="add_description" output="false" access="remote" returntype="boolean" hint="Add description">
<cfargument name="description" required="true" type="string">
INSERT INTO mytable...'#arguments.description#',...etc