> I'm inserting varchar data into a Oracle 8i table using cfqueryparam. For
> some reason, if the data contains a single quote ('), the quote is being
> doubled ('') when it is stored in the database. Is this correct behavior?
No. It is caused by a bug in CF where function calls inside a
cfqueryparam tag fail.
> Can I eliminate this? Would PreserveSingleQuotes() be a valid option here?
Yes.
> I thought the cfqueryParam tag was supposed to take care of this?
It is. But there is a bug in CF. Best thing you can do is fill
out the wishform and complain about this (long standing) issue:
http://www.macromedia.com/go/wish/
Make sure you refer to issue #5230 when you fill out the report:
http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=24832&forumid=4
Jochem
--
When you don't want to be surprised by the revolution
organize one yourself
- Loesje
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]