Got a form that updates a SQL Server database with a several multiline
text fields.
Stuff like "Ted's 8"x12" brochure still needs a little work" gets
entered into these fields
I'm updating multiple rows by appending "_#thisID#)".
The update errors out because of the single quote in the entered text.
I've tried setting a variable like:
<cfset COMV=Replace(Form["COMMENTS_#thisID#"], "'", "&##39;", "all")>
..and then inside the update statement:
COMMENTS='#COMV#'
...but that doesn't seem to be working as it's still throwing an error
any time there's a single quote in the entered text...
Ideas?
--
Les Mizzell
------------------------------------------
Skill without imagination is craftsmanship
and gives us many useful objects such as
wickerwork picnic baskets. Imagination
without skill gives us modern art.
------------------------------------------
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]