Re: The web and Irish names
---
F R E N D Z of martian
---
> > 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
>
> maybe I should change my name to johnO'fdisk then. : )
LOL! John O';Delete from tbl_users might be better ;-)
martian
--
Sent to you via the frendz list at marsbard.com
The archive is at http://www.mail-archive.com/frendz@marsbard.com/
Re: The web and Irish names
---
F R E N D Z of martian
---
> 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
maybe I should change my name to johnO'fdisk then. : )
--
Sent to you via the frendz list at marsbard.com
The archive is at http://www.mail-archive.com/frendz@marsbard.com/
Re: The web and Irish names
---
F R E N D Z of martian
---
Well Theodopolis, glad to see you've chosen the sensible route and changed
your name...
I don't know about NTLworld - I just realised the contractor I know in NTL
is on this list (hi phil) and someone else from a different bit of NTL gets
the digest (hi rachel) so maybe they can get it fixed :-) unlikely though,
at a guess...
- Original Message -
From: John O'Callaghan <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 08, 2000 11:26 PM
Subject: Re: The web and Irish names
> ---
> 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/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/
> >
>
>
> --
> 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: The web and Irish names
---
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/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/
>
--
Sent to you via the frendz list at marsbard.com
The archive is at http://www.mail-archive.com/frendz@marsbard.com/
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/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/
