Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Re: [Alex] Search & Replace

Quote Reply
Re: [Alex] Search & Replace In reply to
How could I replace the \ to / in the texts?

I tried following:
my $cat_sth = $cat_db->do ("UPDATE lsql_category SET Nonenglish = REPLACE(Nonenglish, '\\', '/')");
But I get error: GT::SQL::error = Failed to execute query... It's a syntax error.

What I did wrong?

Best regards,
Webmaster33


Paid Support
from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
Subject Author Views Date
Thread Search & Replace Canoon 2333 Oct 7, 2001, 8:12 AM
Thread Re: [Canoon] Search & Replace
Paul 2205 Oct 7, 2001, 8:56 AM
Thread Re: [RedRum] Search & Replace
Alex 2186 Oct 7, 2001, 1:50 PM
Post Re: [Alex] Search & Replace
Paul 2187 Oct 7, 2001, 1:54 PM
Post Re: [Alex] Search & Replace
Canoon 2187 Oct 8, 2001, 9:04 AM
Post Re: [Alex] Search & Replace
webmaster33 2118 Dec 9, 2002, 8:26 PM