[thelist] U.S. Cities

Luther, Ron Ron.Luther at hp.com
Thu Aug 11 16:54:07 CDT 2005

Dena Marchant asked:

>>Does anyone have suggestions on how to ensure that cities entered 
>>into a database through a web form will be:

>>1. spelled correctly
>>2. valid
>>3. not duplicates

Hi Dena!

Sure.  Make the users select from a tightly controlled list, 
drop-down widget, or series of cascading controls - then (and 
pretty much only then) you will have complete confidence 
that responses will be 'clean'.

Avoid text boxes, those always generate input problems ... 
sometimes spontaneously ... sometimes in concert with pesky 
users mucking up the data.

Good Luck!,


(Who is also wondering which of Angola, New York - Angola, Indiana 
- and Angola, Pennsylvania is the duplicate.  Or which of 'St. Pete', 
'St. Petersburg', or 'Saint Petersburg' will be considered "valid".

Heck, I've never seen a decent sized company who could get their 
_internal_ staff to type *major* customer names and addresses in 
the same way - consistently!  I don't think I'd even try with an 
external audience.)

More information about the thelist mailing list