On 1/24/06, James Harvard <[EMAIL PROTECTED]> wrote:
> It's the Royal Mail. Ordnance Survey, the government mapping agency for the
> UK, are in on it too.
>
> To read their web site (as I have done a couple of years ago, and just now
> too) you would think it had never occurred to them that peopl
It's the Royal Mail. Ordnance Survey, the government mapping agency for the UK,
are in on it too.
To read their web site (as I have done a couple of years ago, and just now too)
you would think it had never occurred to them that people might want to deploy
the data as part of a web site. It's a
rated,
possibly for a fairly affordable price.
Any idea what would prevent the post office from doing that?
Rhino
- Original Message -
From: "sheeri kritzer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Tuesday, January 24, 2006 3
and latitudes, and merge them
together. We spent a lot of time finding that answer, and when we
did, it wasn't cheap.
Sorry for the bad news.
-Sheeri Kritzer
On 1/7/06, Mike Blezien <[EMAIL PROTECTED]> wrote:
> Hello,
>
> we are working with a database that stores UK
Mike Blezien wrote:
Yes, after some further research, I found a Perl Modules that handles
this queit nicely.
thx's
Please tell me where this module is, if you would.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
strict or just the city.
Hope this helps,
Andy
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 09 January 2006 13:12
To: [EMAIL PROTECTED]
Cc: MySQL List
Subject: Re: working w/UK postcodes
I need to do a search query on the columns called
Name of business
OTECTED]
> Sent: 09 January 2006 13:12
> To: [EMAIL PROTECTED]
> Cc: MySQL List
> Subject: Re: working w/UK postcodes
>
> > I need to do a search query on the columns called
> >
> > Name of business "the name of the business"
> > Town &qu
Yes, after some further research, I found a Perl Modules that handles this queit
nicely.
thx's
[EMAIL PROTECTED] wrote:
I need to do a search query on the columns called
Name of business "the name of the business"
Town "Local town or city name"
Postcode" this is the same
> I need to do a search query on the columns called
>
> Name of business "the name of the business"
> Town "Local town or city name"
> Postcode" this is the same as your zip code"
> Category"this is type of business ie dress shop bakers"
> XY "this is the t
Hello,
I need to do a search query on the columns called
Name of business "the name of the business"
Town "Local town or city name"
Postcode" this is the same as your zip code"
Category"this is type of business ie dress shop bakers"
XY "this is the table
Hello,
we are working with a database that stores UK postcodes, which are different
then US zipcodes. I've found alot of information for working with zipcodes,
locating closed distances within a zipcode range, but haven't found anything
regarding working with UK type postcodes.
Hello,
we are working with a database that stores UK postcodes, which are different
then US zipcodes. I've found alot of information for working with zipcodes,
locating closed distances within a zipcode range, but haven't found anything
regarding working with UK type postcodes.
Hello,
we are working with a database that stores UK postcodes, which are different
then US zipcodes. I've found alot of information for working with zipcodes,
locating closed distances within a zipcode range, but haven't found anything
regarding working with UK type postcodes.
it's not *that* important
since the way it's ordered now is the same as many (if not all) file systems
do.
> If sorting by number is important, then split them on input and
> store them
> in two separate files. But I don't really know why you'd want to
> sort
Hi,
yes, that would do, except that I don't know how many letters are in front
of the numbers.
And since they're not the same letters perhaps ORDER by 1,2 would have done
it perfectly, if only we could substring() intelligently first.
Cheers,
Damien COLA
> -Message d'origine-
> SQL:
> sel
Thank you and Yes, separating the postcodes into field letters and numbers
may be the only way to be able to order a sequence like that:
CV1,CV2,..,CV10,..
It would also work since there could as many letters as needed
Anyone has a simple query for odering sequences correctly ?
Cheers,
Damien COL
imple ORDER BY query
> E1,E2,E3,E4,E5,... ?
If sorting by number is important, then split them on input and store them
in two separate files. But I don't really know why you'd want to sort them
numerically anyway - UK postcodes aren't sequential in operation: E1 is not
necessaril
PM
To: MySQL List
Subject: RE: Sorting UK Postcodes (WAS Sorting Results)
Sorry, I forgot to say that postcode can be one or 2 letters in front of the
numbers.
> -Message d'origine-
> They can be E1,E2,..,E12,E13
> Order by name would do:
> E1,E10,E11,E12,E13,E2,E3,E4,..
/12/2002 +0100, Alliax wrote:
Hi,
What about if you want to sort UK Postcodes ?
They can be E1,E2,..,E12,E13
Order by name would do:
E1,E10,E11,E12,E13,E2,E3,E4,...
how can I get with a simple ORDER BY query
E1,E2,E3,E4,E5,... ?
Cheers,
Damien COLA
Sorry, I forgot to say that postcode can be one or 2 letters in front of the
numbers.
> -Message d'origine-
> They can be E1,E2,..,E12,E13
> Order by name would do:
> E1,E10,E11,E12,E13,E2,E3,E4,...
> how can I get with a simple ORDER BY query
> E1,E2,E3,E4,E5,... ?
-
Hi,
What about if you want to sort UK Postcodes ?
They can be E1,E2,..,E12,E13
Order by name would do:
E1,E10,E11,E12,E13,E2,E3,E4,...
how can I get with a simple ORDER BY query
E1,E2,E3,E4,E5,... ?
Cheers,
Damien COLA
-
Before
21 matches
Mail list logo
