RE: Database of US Zip Codes

2001-03-12 Thread Brandon Behrens
: 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

Re: Database of US Zip Codes

2001-03-12 Thread Kent A. Orso
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

RE: Database of US Zip Codes

2001-03-12 Thread JoshMEagle
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

RE: Database of US Zip Codes

2001-03-08 Thread paul smith
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

RE: Database of US Zip Codes

2001-03-08 Thread Seamus Campbell
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 codes) > > > >1. is it better, qu

RE: Database of US Zip Codes

2001-03-08 Thread Judith Campbell
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 drop-down box in a

RE: Database of US Zip Codes

2001-03-08 Thread Seamus Campbell
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 application.cfm

Re: Database of US ZIP CODES

2001-03-08 Thread Tom Nunamaker
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

Re: Database of US Zip Codes

2001-03-08 Thread Michael
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

RE: Database of US Zip Codes

2001-03-08 Thread Randi Knutson
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 > > > >

Re: Database of US ZIP CODES

2001-03-08 Thread Michael Barnum
$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

RE: Database of US ZIP CODES

2001-03-08 Thread Dylan 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 Subject: RE: Database of US ZIP CODES You can get it for $150 USD at http://www.tpsnet.com

RE: Database of US ZIP CODES

2001-03-08 Thread Duane Boudreau
You can get it for $150 USD at http://www.tpsnet.com/html/zipcode.html I just finished a stored procedure that does a distance calculation and locates all zips with in a given radius if that is what you are trying to accomplish. Duane -Original Message- From: Michael [mailto:[EMAIL PRO