Re: Quotation marks in string causing repace to not work.

2005-07-25 Thread Ludwig Pummer
Gregory Machin wrote: I tried the following UPDATE temp SET 'file_content' = REPLACE(file_content, '' , ''); but it didn't work, i think thing problem is that the string i need to replace / null has quotation marks .. how can i work around this You need to escape the quotation marks. A

Quotation marks in string causing repace to not work.

2005-07-25 Thread Gregory Machin
Hi Please could you advise. I inserted some web pages into a table and now i need to do updates to the pages so that the cms can display them with out the legacy code. there are about 1000 pages. I tried the following UPDATE temp SET 'file_content' = REPLACE(file_content, '' , ''); but it di