Path: utzoo!telecom-request Date: Thu, 16 May 91 19:06:42 EDT From: Ken Levitt Newsgroups: comp.dcom.telecom Subject: One City With Two Area Codes Message-ID: Organization: TELECOM Digest Sender: Telecom@eecs.nwu.edu Approved: Telecom@eecs.nwu.edu X-Submissions-To: telecom@eecs.nwu.edu X-Administrivia-To: telecom-request@eecs.nwu.edu X-Telecom-Digest: Volume 11, Issue 375, Message 10 of 11 Lines: 36 We have a new software product that provides office and practice management for veterinarians. Because the users of the system are often low level clerical staff with no prior exposure to computers, our system makes every possible attempt to verify all data entry fields. When the system is first installed, the system administrator builds a database of cities in the area. One field in the database contains the area code. When a phone number is entered, the system requires that the area code matches the area code for that city. All this worked fine until today when a new client informed me that Westlake Village, CA has two area codes (805/818). This was something that I had never considered possible. My choices are either to hard code a check for that one city in the program, or change the database structure and modify the program to account for this happening again in another city. Are there other cities in the country with two area codes? If I sell another 500 copies of my program, how likely am I to run across another one of them? Ken Levitt - On FidoNet gateway node 1:16/390 UUCP: zorro9!levitt INTERNET: levitt%zorro9.uucp@talcott.harvard.edu [Moderator's Note: I'd think that with the numerous area code splits going on in metro areas, your scenario could become quite common. How does your program now deal with (post office) New York, NY? At the outer edges of suburbia here, some communities sit right on the 815/708 line, including Fox Lake and Lockport/Romeoville, IL. PAT]