RE: Database of US Zip Codes
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 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) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 Zip Codes 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 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) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database of US Zip Codes
Here you go. These are at least 1.5 years old. They seem to be reasonably accurate. Brandon Behrens Developer Momentum Software http://www.momentumsoftware.com/ [EMAIL PROTECTED] -Original Message- From: Kent A. Orso [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 8:42 AM To: 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 Zip Codes 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 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) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database of US ZIP CODES
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 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 your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database of US ZIP CODES
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/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 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 your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Database of US ZIP CODES
All I need though is zip, and town and state, nothing else, isnt there something cheaper? THanks Michael "Dylan Bromby" [EMAIL PROTECTED] wrote in message news:001a01c0a7fc$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 Subject: RE: Database of US ZIP CODES 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 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 your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database of US Zip Codes
You could just download it from the US Census at http://www.census.gov/geo/www/tiger/zip1999.html You'll need to change their state numbers to the right abbr, but otherwise it's useable. "Michael Barnum" [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... All I need though is zip, and town and state, nothing else, isnt there something cheaper? THanks Michael "Dylan Bromby" [EMAIL PROTECTED] wrote in message news:001a01c0a7fc$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 Subject: RE: Database of US ZIP CODES 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 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 your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Database of US Zip Codes
Thank you, do you know if they update and put newer ones out from time to time? Michael "Randi Knutson" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... You could just download it from the US Census at http://www.census.gov/geo/www/tiger/zip1999.html You'll need to change their state numbers to the right abbr, but otherwise it's useable. "Michael Barnum" [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... All I need though is zip, and town and state, nothing else, isnt there something cheaper? THanks Michael "Dylan Bromby" [EMAIL PROTECTED] wrote in message news:001a01c0a7fc$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 Subject: RE: Database of US ZIP CODES 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 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 your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Database of US ZIP CODES
Did you ask the US Postal Service? At 07:42 PM 3/8/01, you wrote: All I need though is zip, and town and state, nothing else, isnt there something cheaper? THanks Michael "Dylan Bromby" [EMAIL PROTECTED] wrote in message news:001a01c0a7fc$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 Subject: RE: Database of US ZIP CODES 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 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 your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database of US Zip Codes
html font size=3This is maybe slightly off-topic and possibly a dumb question, butbr br with a long list which rarely changes (such as zip codes)br br 1. is it better, quicker to have them as a list rather than a query, say in a drop-down box in a form.br br 2. Is it good practice to have it as a query in an application.cfm (server or application scope)br br 3. if a list is good practice how do you set this up and then access it laterbr br or is there a better way altogetherbr br hope this makes sense br br seamus/font/html ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database of US Zip Codes
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 form. A short list, like states, is better as a list because the program can read the entire list in less time than it could do a database read. A list of zip codes, however, which is massive, is much better in a relational table, especially since you're usually only returning one record on the zip code match and the query into the relational table would be much faster than searching the entire list sequentially. 2. Is it good practice to have it as a query in an application.cfm (server or application scope) I don't see any benefit from carrying a variable of this size around thru the whole app. Just include or query at the point in the code where you need it. 3. if a list is good practice how do you set this up and then access it later or is there a better way altogether See above. Judith Campbell Chief Technical Officer Digital Positions, Inc. [EMAIL PROTECTED] 404-351-9366 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database of US Zip Codes
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, quicker to have them as a list rather than a query, say in a drop-down box in a form. A short list, like states, is better as a list because the program can read the entire list in less time than it could do a database read. A list of zip codes, however, which is massive, is much better in a relational table, especially since you're usually only returning one record on the zip code match and the query into the relational table would be much faster than searching the entire list sequentially. 2. Is it good practice to have it as a query in an application.cfm (server or application scope) I don't see any benefit from carrying a variable of this size around thru the whole app. Just include or query at the point in the code where you need it. 3. if a list is good practice how do you set this up and then access it later or is there a better way altogether See above. Judith Campbell Chief Technical Officer Digital Positions, Inc. [EMAIL PROTECTED] 404-351-9366 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database of US Zip Codes
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) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
