Barney Boisvert wrote:
REreplace is a CF function, not a MySQL function, which is why you're
getting the error. MySQL has a 'replace' function though. Something
like this should work:
UPDATE myDATE SET
textfield = replace(textfield, Õ,')
That gives a syntax error as well.
MySQL
OK, running the below directly in the database worked fine.
UPDATE `textfield` SET `Logline` = REPLACE(`textfield`,Õ,')
Can't get an equilivent Coldfusion query to work though. Ideas?
--
---
Les Mizzell
~|
Find
textfield = replace(textfield, 'Õ',''')
That errors as well
You cannot use the same character (single quote) as a string and its
delimiter in the same time.
Check wih the MySQL syntax for escaping single quotes.
Then you probabily need to use the preserveSingleQuotes() function in
the
I've been handed a mySQL database with weird stuff in some text fields:
Õ instead of ' - for example
or things like ÒSet For LifeÓ for left and right quotes
I'd like to run a query and remove all these using rereplace, but a test
query like the below is returning an error
cfloop query=myQUERY
REreplace is a CF function, not a MySQL function, which is why you're
getting the error. MySQL has a 'replace' function though. Something
like this should work:
UPDATE myDATE SET
textfield = replace(textfield, Õ,')
Rip out part of the table into a temp table to test against so you can
ensure
5 matches
Mail list logo