that crash the oracle drivers in CFMX 6.1.
I have a UDF that theoretically should take care of single and double
quotes, em and en dashes, and bullets. If I do a hardcoded test like this:
<cfset mytext = "This is a . bullet">
<cfoutput>
Unconverted: #mytext#<br>
Converted: #convertspecialchars(mytext)#
</cfoutput>
It works just fine. I'm converting the bullet to *. If I run it in an insert
statement, either doing the function before the insert and using my cleaned
text for the insert, or doing the function directly in the insert, it does
nothing, and I end up with an upside down question mark in the database.
And, yes, I'm using cfqueryparams.
It only crashes with clob fields, with more than 2000 characters, though
those upside down question marks don't look good in any field.
I've been working on this all day, and I'm really hoping I'm missing
something basic.
(CFMX 6.1, linux, Oracle 8.1.7)
--
Deanna Schneider
UWEX-Cooperative Extension
Interactive Media Developer
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
