---
F R E N D Z of martian
---
Thanx for the explaination
A decent explaination is what I asked for and that is just what I got
and a bit of perl into the bargain ; )
I am that good at perl yet but at Least Irish people (and people with
spainish addresses) will be ok with my database and scripts.
[snip]
> If this happened to be in the WebTV part of ntl I could probably get it
> fixed as I know a contractor there.
>
[snip]
Well it is part of the ntlworld.com is that the same dept.? I have
mentioned it them but It is still %27 on the maillist.
but hey, 0800 net access and national calls and local rates you can call me
"theodopolis aardvark" for all I care!
----- Original Message -----
From: Martin Cosgrave <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 08, 2000 5:36 PM
Subject: Re: The web and Irish names
> ---
> F R E N D Z of martian
> ---
>
> Support status: closed
> Problem: User error in name
> Outcome: Dispatched deed poll form
>
>
> ----- Original Message -----
> From: John O'Callaghan <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, June 08, 2000 5:30 PM
> Subject: The web and Irish names
>
>
> > ---
> > F R E N D Z of martian
> > ---
> > Dear Frendz of marsbard
> > Can anyone explain why the Web does not like Irish names.
> >
> > my surname is O'Callaghan
> >
>
> Crappy coding - apostrophes break SQL ("insert into names (surname) values
> ('O'Callaghan')" - as you can see there's a disparity of apostrophes - SQL
> will stop after 'O' and see an unknown command "Callaghan" and die. Which
is
> why it has to be escaped "insert into names (surname) values
> ('O\'Callaghan')" (backslash) or "insert into names (surname) values
> ('O''Callaghan')" (double) dependent on the server
>
> > but ntl have it has O%27Callaghan
>
> If this happened to be in the WebTV part of ntl I could probably get it
> fixed as I know a contractor there.
>
> > compfutures made it O\"\"Callaghan
> stupid escape... shoot the coders
>
> > and quite a few have just choked
> didn't anticipate any names with apostrophes...
>
>
> >
> > Is an a apostrophe really that difficult to deal with?
> > or is it just lazy script writers only going for A-Z ?
> >
> > I know that it is a perl script thing the %27 thing (please correct me
if
> I
> > am wrong)
> URL-escaped apostrophe
>
>
> > but a decent explaination would be nice.
> >
> > the last thing you want is a load of angry Irish surfers!
> >
> > Thanx in advance
> > John
> >
> >
> >
> >
> > --
> > Sent to you via the frendz list at marsbard.com
> >
> > The archive is at http://www.mail-archive.com/[email protected]/
>
>
> --
> Sent to you via the frendz list at marsbard.com
>
> The archive is at http://www.mail-archive.com/[email protected]/
>
--
Sent to you via the frendz list at marsbard.com
The archive is at http://www.mail-archive.com/[email protected]/
