in my zip code database, it's
in the store database, but the CFC isn't including it within the list of zip
codes returned.
What's strange is when Imenaully query the store database for the following
query, I still get stores that have no zip code value and some lats and longs
tha
a user is in from their IP?
>
>
> No, as one ISP can service many zip codes, and in many cases many states.
> The addresses are rotated out dynamically to users in most cases, so an IP
> may be in one zip code on one request, and another zip code on the next
> request if two peop
> I know that one can get a geographic location for a
> given IP, but does anyone know if there is a way to
> get the Zip Code a user is in from their IP?
No, as one ISP can service many zip codes, and in many cases many states.
The addresses are rotated out dynamically to users in most
I know that one can get a geographic location for a given IP, but does
anyone know if there is a way to get the Zip Code a user is in from
their IP?
I doubt this is possible, and all my research points to NO, but I'd
never know for sure if I didn't ask...
--
===
phically, but would love the
> ability for
> someone to enter a zip code and find the listings in the zip codes in
> a
> certain area around that zip code.
>
> Ray
>
> At 04:06 PM 3/31/2004, Steve Logan wrote:
> >I read the thread a few weeks about about distance ra
I would definitely be interested in this too. We have a directory style
site that people can search geographically, but would love the ability for
someone to enter a zip code and find the listings in the zip codes in a
certain area around that zip code.
Ray
At 04:06 PM 3/31/2004, Steve Logan
What do you mean by "neighboring"? To me, every zipcode "neighbors"
eachother.
> I read the thread a few weeks about about distance radius
> searching for US zip codes, but - what about doing
> neighboring zip codes. I have a client that seems to prefer
> t
I read the thread a few weeks about about distance radius searching for US zip codes, but - what about doing neighboring zip codes. I have a client that seems to prefer the idea of seeing every zip code that is next to the one searched for. Is anyone aware of a db that can be purchased out there
several people were kind enough to send me databases with the zip codes. Now
heres what i need to do with it.
a user register's which includes their zip code.
BTW~ this is a singles site..
so if you as a user where to look at another users profile, it would tell
you how many miles away yo
al Message-
From: Andy Ousterhout [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 18, 2003 4:31 PM
To: CF-Talk
Subject: RE: distance between zip codes
Search the archives. Basically, buy a DB that provides ZIP Code to lat
longitude, then calculate. Here is one post that I saved .
For thos
-Novak
- Original Message -
From: "Andy Ousterhout" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, January 18, 2003 4:30 PM
Subject: RE: distance between zip codes
> Search the archives. Basically, buy a DB that provides ZIP Code
uire since I've done the conversion
within the latlondist UDF.
Rob's version is here:
http://www.cflib.org/udf.cfm?ID=73
-Original Message-
From: Dave Lyons [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 18, 2003 6:09 PM
To: CF-Talk
Subject: distance between zip codes
any
nt: Wednesday, August 28, 2002 5:34 PM
Subject: RE: Canadian Zip Codes
> Does anyone know of a *free* source of Canadian postal codes with lat/lon
> data?
>
> -paris
>
> -Original Message-
> From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesda
Does anyone know of a *free* source of Canadian postal codes with lat/lon
data?
-paris
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 5:41 PM
To: CF-Talk
Subject: Re: Canadian Zip Codes
*AHEM* that's postal codes to you
media.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
- Original Message -
From: "Robert Weimer" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 28, 2002 12:48 PM
Subjec
Does anyone know of a custom tag that works with Canadian zip codes in the
same way that ZipRad does? (i.e. distance from city to city, zip codes
within a radius, etc.)
Thanks,
Rob
__
Your ad could be here. Monies from ads
t; zip codes database?
For just city and state:
http://www.usps.com/ncsc/lookups/lookup_ctystzip.html
-- sam
-Original Message-
From: Craig Thomas [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 8:11 AM
To: CF-Talk
Subject: RE: states -> counties -> zip codes database?
lto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 10:15 AM
To: CF-Talk
Subject: RE: states -> counties -> zip codes database?
For just city and state:
http://www.usps.com/ncsc/lookups/lookup_ctystzip.html
-- sam
-Original Message-
From: Craig Thomas [mailto:[EMAIL PROTECTED]]
Sent
For just city and state:
http://www.usps.com/ncsc/lookups/lookup_ctystzip.html
-- sam
-Original Message-
From: Craig Thomas [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 8:11 AM
To: CF-Talk
Subject: RE: states -> counties -> zip codes database?
>Bump, can anyon
>Bump, can anyone help me out with this? This has to be a common question.
> > Anyone know of an updated database as mentioned in the
> subject line -
> > preferably one that stores the relationships between counties
> > -> zip codes?
http://www.usps.com/sear
Zipinfo.com
---
Billy Cravens
-Original Message-
From: Cantrell, Adam [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 9:49 AM
To: CF-Talk
Subject: RE: states -> counties -> zip codes database?
Bump, can anyone help me out with this? This has to be a common
qu
Bump, can anyone help me out with this? This has to be a common question.
> > Anyone know of an updated database as mentioned in the
> subject line -
> > preferably one that stores the relationships between counties
&
Sorry for the cross post, I accidentally posted this to cf-community.
> Anyone know of an updated database as mentioned in the subject line -
> preferably one that stores the relationships between counties
> -&g
Sweet! This one worked - the ORDER BY (count)zipcode threw an
error,(may be Access).
Thanks much!
Jim
CR>
CR>SELECT DISTINCT zipcode, count(zipcode) as zipnum
CR>FROMtblSurvey
CR>WHERE state = '#URL.state#'
CR>GROUP BY zipcode
CR>ORDER BY 2, zipcode
CR>
__
Hi Jim,
you can try
SELECT DISTINCT zipcode, count(zipcode) as zipnum
FROMtblSurvey
WHERE state = '#URL.state#'
GROUP BY zipcode
ORDER BY count(zipcode), zipcode
or
depending on your database
SELECT DISTINCT zipcode, count(zipcode) as zipnum
FROMtblSurvey
W
I've inherited a table with the usual name, address, city, state, zip.
I've been asked if I can sort the list via ZIP code and have the
output sorted by the zip code - most popular first, and I'm stumped.
So far I've got this:
SELECT DISTINCT zipcode, count(zipcode) as zipnum
FROMtblSu
T." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, January 12, 2002 9:17 AM
Subject: RE: CF and Zip Codes
> Basically what I am doing to clarify things is the following:
> I wanna be able to search for stores in my database and get the store
x27;m always looking :-)
-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 12, 2002 12:18 PM
To: CF-Talk
Subject: RE: CF and Zip Codes
Basically what I am doing to clarify things is the following:
I wanna be able to search for stores in my
Sent: Saturday, January 12, 2002 9:18 AM
> To: CF-Talk
> Subject: RE: CF and Zip Codes
>
>
> Basically what I am doing to clarify things is the following:
> I wanna be able to search for stores in my database and get
> the stores within x number of miles from the visitors
> e
Message-
From: Jeff Beer [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 12, 2002 11:35 AM
To: CF-Talk
Subject: RE: CF and Zip Codes
Hey - Michael - I read your message wrong. If all you need is the distance
between two zips you can have that tag for free. It won't do the radius
uary 12, 2002 9:14 AM
Subject: CF and Zip Codes
> Has anyone ever done this or know a good way to do it..
> I need to calculate the distance between 2 zip codes using Cold Fusion.
>
> Michael T. Tangorre
>
>
> Resident Assistant - Brick
&g
EMAIL PROTECTED]]
Sent: Saturday, January 12, 2002 11:14 AM
To: CF-Talk
Subject: CF and Zip Codes
Has anyone ever done this or know a good way to do it..
I need to calculate the distance between 2 zip codes using Cold Fusion.
Michael T. Tangorre
Resident Assistant -
ry 12, 2002 11:14 AM
To: CF-Talk
Subject: CF and Zip Codes
Has anyone ever done this or know a good way to do it..
I need to calculate the distance between 2 zip codes using Cold Fusion.
Michael T. Tangorre
Resident Assistant - Brick
Web Applications Developer
A.U. We
Has anyone ever done this or know a good way to do it..
I need to calculate the distance between 2 zip codes using Cold Fusion.
Michael T. Tangorre
Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave :-)
AIM: CrazyFlash4
iday, December 07, 2001 9:41 AM
> Subject: RE: If anyone else needs zip codes just speak up.
>
> > Sorry to be a PITA, but does this type of traffic REALLY need to go via
> > the CF-Talk list?
> >
> > Can't they be sent personally?
> >
> > There
A PITA Isnt that mexican bread lol :)
Doug
- Original Message -
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, December 07, 2001 9:41 AM
Subject: RE: If anyone else needs zip codes just speak up.
f you have received this email in error please notify
the system manager.
**
> -Original Message-
> From: Kris Pilles [mailto:[EMAIL PROTECTED]]
> Sent: 07 December 2001 17:33
> To: CF-Talk
> Subject: RE: If an
Thanks for the offer Doug. I could use a copy please.
Regards,
Paul Sinclair
> -Original Message-
> From: Douglas L. Brown [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 29, 2001 4:39 PM
> To: CF-Talk
> Subject: If anyone else needs zip codes just speak up.
>
else needs zip codes just speak up.
Can I have a copy please?
TIA
Thanh
-Original Message-
From: Douglas L. Brown [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 1:39 PM
To: CF-Talk
Subject: If anyone else needs zip codes just speak up.
Just though I would share the zip
Can I have a copy please?
TIA
Thanh
-Original Message-
From: Douglas L. Brown [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 1:39 PM
To: CF-Talk
Subject: If anyone else needs zip codes just speak up.
Just though I would share the zip codes with whoever might need them
give me a copy please...
-paris
-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 16:41
To: CF-Talk
Subject: Re: If anyone else needs zip codes just speak up.
Do you know when it was updated? My latest is from April, 2001.
If it is
Douglas,
I wouldn't mind getting a list of zip codes will come in handy for a
project coming up..
Thanks
- Original Message -
From: "Douglas L. Brown" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 29, 2001 3:39
I believe it is around the same time Jerry.
doug
- Original Message -
From: "Jerry Johnson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 29, 2001 1:40 PM
Subject: Re: If anyone else needs zip codes just speak up.
&
Do you know when it was updated? My latest is from April, 2001.
If it is newer than that, I'd love a copy.
Please.
to [EMAIL PROTECTED]
Thanks in advance
Jerry Johnson
>>> [EMAIL PROTECTED] 11/29/01 04:39PM >>>
Just though I would share the zip codes with whoever mig
Just though I would share the zip codes with whoever might need them.
Just let me know
http://www.carnivorepc.com";>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
F
As a comparison, my ZipRad custom tag finds all zips within 10 miles of
a given zip in about 203ms (returning 53 zip codes). This is using an
MSAccess 2000 db with ODBC. I'll try it with SQL Server 2000 this
weekend.
Just for fun, I ran it with a radius of 99 miles using a Chicago zip
itching for timings on this too :)
-paris
[finding the future in the past, passing the future in the present]
[connecting people, places and things]
-Original Message-
From: "Correa, Orlando (ITSC)" <[EMAIL PROTECTED]>
Date: Thu, 09 Aug 2001 12:33:42 -0600
Subject: RE:
Any quantification of execution time for "spankin fast"? on the 43,000
record table?
-Original Message-
From: Edward Smith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 09, 2001 8:50 AM
To: CF-Talk
Subject: Re: Zip Codes
Well, we've used it :) I just cut it out o
tered Zip code
(query against about 43,000 zip codes)
3) (Optional) Query against Zip+4 table filtering on the Zip5, so you
are only hitting the rows that have the main zipcode returned by step 2
4) Query your location table for locations with the resulting zipcodes
Paris Lundis wrote:
>
>
it is
people searching for other people or places based on where they are or
will be... QUite typical use I think...
Interested in everyone's input..
-paris
-Original Message-
From: Edward Smith <[EMAIL PROTECTED]>
Date: Tue, 07 Aug 2001 14:45:48 -0500
Subject: Re: Zip Cod
I have a stored proc written for SQL Server. Let me know if you want it.
Duane
-Original Message-
From: Rey Bango [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 2:43 PM
To: CF-Talk
Subject: Zip Codes
Hey all. I need to build a routine that will allow a site visitor to
Here's the important code - I think this works in Access, probably
SQLServer as well. You need a database with zipcodes, longitude, and
latitude. This assues Lon/Lat in degrees.
This code takes in a radius, and returns all the zipcodes within that
radius:
select longitude,latitude f
-Original Message-
From: Rey Bango [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 1:43 PM
To: CF-Talk
Subject: Zip Codes
Hey all. I need to build a routine that will allow a site visitor to find a
store within "x" miles of a specific zip code. Has anyone done this before
Hey all. I need to build a routine that will allow a site visitor to find a
store within "x" miles of a specific zip code. Has anyone done this before
and if so, would you mind lending some guidance? If anyone knows of a custom
tag to do this, that would great.
Thanks,
Rey Bango
Team Allaire...
: CF-Talk
Subject: Re: Database of US Zip Codes
Check out CF_STATE on the Allaire Tag Gallery
- Original Message -
From: "JoshMEagle" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 12, 2001 8:52 AM
Subject: RE: Database of US
Check out CF_STATE on the Allaire Tag Gallery
- Original Message -
From: "JoshMEagle" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 12, 2001 8:52 AM
Subject: RE: Database of US Zip Codes
Anyone know of a pre-existing database
Anyone know of a pre-existing database of US zips/cities?
Proabably a shot in the dark, but a shot I'm willing to take.
JoshM
-Original Message-
From: paul smith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 08, 2001 8:26 PM
To: CF-Talk
Subject: RE: Database of US Zip Codes
P
Put it in a request-scoped cached query instead and you won't have any
locking worries.
best, paul
At 08:26 AM 3/9/01 +1100, you wrote:
>2. Is it good practice to have it as a query in an application.cfm (server
>or application scope)
~~
Stru
many thanks - much help.
seamus
At 11:22 am 9/03/01 , you wrote:
>At 08:26 AM 3/9/01 +1100, you wrote:
> >This is maybe slightly off-topic and possibly a dumb question, but
>
>There are no dumb questions.
>
>
> >with a long list which rarely changes (such as zip co
At 08:26 AM 3/9/01 +1100, you wrote:
>This is maybe slightly off-topic and possibly a dumb question, but
There are no dumb questions.
>with a long list which rarely changes (such as zip codes)
>
>1. is it better, quicker to have them as a list rather than a query, say
>in a dro
This is maybe slightly off-topic and possibly a dumb
question, but
with a long list which rarely changes (such as zip codes)
1. is it better, quicker to have them as a list rather than a query, say
in a drop-down box in a form.
2. Is it good practice to have it as a query in an
1c0a7fc$dfb126a0$6401a8c0@bromby>...
> > their data is good. i've used it for years. used to be $35.
> >
> > -Original Message-
> > From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, March 08, 2001 10:21 AM
> > To: CF-Talk
ta is good. i've used it for years. used to be $35.
> > >
> > > -Original Message-
> > > From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, March 08, 2001 10:21 AM
> > > To: CF-Talk
> > > Subject: RE: Database of
eir data is good. i've used it for years. used to be $35.
> >
> > -Original Message-
> > From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, March 08, 2001 10:21 AM
> > To: CF-Talk
> > Subject: RE: Database of US ZIP CODES
> >
> >
$35.
>
> -Original Message-
> From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 08, 2001 10:21 AM
> To: CF-Talk
> Subject: RE: Database of US ZIP CODES
>
>
> You can get it for $150 USD at http://www.tpsnet.com/html/zipcode.html
>
> I ju
their data is good. i've used it for years. used to be $35.
-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 08, 2001 10:21 AM
To: CF-Talk
Subject: RE: Database of US ZIP CODES
You can get it for $150 USD at http://www.tpsnet.com
PROTECTED]]
Sent: Thursday, March 08, 2001 1:05 PM
To: CF-Talk
Subject: OT: Database of US ZIP CODES
Anyone know of where I can get this, and reasonably accurate and up to
date...
I may be asking too much , but hey cant hurt right.
~~
Structure
Anyone know of where I can get this, and reasonably accurate and up to
date...
I may be asking too much , but hey cant hurt right.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkin
What is the address for those of us willing to wait.
Robert Everland III
Web Developer
Dixon Ticonderoga
-Original Message-
From: Mark Warrick [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 10, 2000 1:34 PM
To: [EMAIL PROTECTED]
Subject: RE: Checking zip codes against USPS
Yes, there
Yes, there are several custom tags that you could probably use to do this. Or you
could download the zip codes database from the UPSP and build something yourself.
You're looking for the "Tiger/Zip" database which is updated each month by the USPS.
If the USPS site wasn'
I've got a database that receives new addresses/zip codes from a web form on
a daily basis. I would like to eliminate addresses that have a non-existent
zip code. Is there some way to automate a function that will verify the zip
codes in the database against a USPS list of zip codes on a
Bud is the man.
www.jcsm.com.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'un
zip.com.au
On Fri, 16 Jun 2000, Webmaster wrote:
> I don't, but check out www.zipfind.net. It looks like a pretty comprehensive
> program using zip codes.
>
> Todd Hopkins
> High Country Computers
>
> - Original Message -
> From: "Nick McClure" <
yeah that would be handy. Someone else recommended once to create a
repository of database tables somewhere. Good idea.
Eric
From: Nick McClure <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: OT: Zip Codes
Date: Tue, 13 Jun 2000 12:14:22 -0400
Does anybod
I don't, but check out www.zipfind.net. It looks like a pretty comprehensive
program using zip codes.
Todd Hopkins
High Country Computers
- Original Message -
From: "Nick McClure" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 13, 2000 10:1
Consulting Partner
- Original Message -
From: "Nick McClure" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 13, 2000 11:14 AM
Subject: OT: Zip Codes
> Does anybody have a list of zip codes and the city, state, county they are
in.
> --
>
ick McClure [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 13, 2000 12:14 PM
> To: [EMAIL PROTECTED]
> Subject: OT: Zip Codes
>
>
> Does anybody have a list of zip codes and the city, state,
> county they are in.
> --
> Nick McClure [EMAIL PROTECTED]
> Techni
Does anybody have a list of zip codes and the city, state, county they are in.
--
Nick McClure[EMAIL PROTECTED]
Technical Director 606.245.9656
squareFish Mediawww.squareFish.com
--
Archives
The JCS zip code tables..what fields are in this table?
It seems like its the table most folks use for loactors no?
John
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.co
79 matches
Mail list logo
