Re: Irish Names and Forms.
--- 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/
RE: Irish Names and Forms.
--- F R E N D Z of martian --- > $text =~s/\'/\\\'/gm; ? I'll get my coat... Brownie (hmlt specialist) -Original Message- From: Martin Cosgrave [mailto:[EMAIL PROTECTED]] Sent: Friday, June 09, 2000 11:24 AM To: multiple recipients of Subject: Re: Irish Names and Forms. --- 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/ -- Sent to you via the frendz list at marsbard.com The archive is at http://www.mail-archive.com/frendz@marsbard.com/
Re: Irish Names and Forms.
--- 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/