---
F R E N D Z of martian
---
In actual fact (I think), solely ' gets placed in the database because
the extra \' just escapes the sequence,
and is ignored by (in this case) MySQL.
The m is just for good measure!
Mike.
Martin Cosgrave wrote:
---
F R E N D Z of martian
---
$text =~s/\'/\\\'/gm;
I would normally have it $text =~ s/\'/\\'/g; (dunno quite what m does in
yours - the camel book says 'treat as multiple lines' but not sure what that
means! g normally works for me)
Looks like you're storing the literal string \' into the database, whereas
with mine it stays as ' once it has got through the SQL parser.
Am I missing something...?
martian
(usual apols to non-techies)
--
Sent to you via the frendz list at marsbard.com
The archive is at http://www.mail-archive.com/frendz@marsbard.com/
--
Mike Harris
Open Systems and Internet Consultant
Psand España, C/ de l'Encarnació 35 2º 2ª
08012 Barcelona, Spain
Tel: +34 93 213 6872 / +34 69 676 3122
Website: www.psand.net
--
Sent to you via the frendz list at marsbard.com
The archive is at http://www.mail-archive.com/frendz@marsbard.com/