I've got a simple UPDATE query operating in CF5 on an Access 2000 db via
ODBC.  If a CF function call is used within the query statement for a
string value, then any single quotes get doubled.  Without the function
call this doesn't happen.

UPDATE mytable
SET somefield = '#StripHTML(form.somefield)#'
WHERE ...

vs.

UPDATE mytable
SET somefield = '#form.somefield#'
WHERE ...

Explanation?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to