This content has been marked as final. Show 4 replies
In short, I need to search for and escape the \ character in a field prior
Ok, first I am looking for the character using <cfif #field# CONTAINS
"\">'Error'<cfelse>'#field#'</cfif> and that is working so far. Now I just
need to escape the \.
I am going to try replace(#field#, "\", "\\", "ALL").
Will that work or any better ideas?
What happened when you tried it? Did you have a similar problem with apostrophes?
cfqueryparam will probably escape all the weird characters you are likely to encounter.
It seemed to have worked. I managed to loop and insert 55,345 records
without a hitch. I may move it to a cfqueryparam and see if that works too.
"Dan Bracuk" <firstname.lastname@example.org> wrote in message
> What happened when you tried it? Did you have a similar problem with
> cfqueryparam will probably escape all the weird characters you are likely
> to encounter.