---
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/[email protected]/
--
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/[email protected]/
