So check this out:
I’ve never seen this kind of error before. All of Minnesota’s cities are classified under Mississippi. If you look under Minnesota, you see Missouri’s cities. Maryland has the right cities, but Massachusetts has Portland and Bangor (in Maine). What’s going on here?
The first thing I checked was the drop-down menu, thinking that the label and the value for the states might be out of alignment (MO – Minnesota, MN – Mississippi, etc.). But no, the drop-down has values equal to the labels, so you’re choosing Minnesota and it’s going to the database to pull whatever it has for Minnesota, not the state called “MN” or the state with StateID = 22.
Bummer for them. I bet this happened because someone had an assumption somewhere that the abbreviations of the states alphabetize the same as the names of the states, but this isn’t true.
| States beginning with M, alphabetized | |
| names | abbr |
| Maine | MA |
| Maryland | MD |
| Massachusetts | ME |
| Michigan | MI |
| Minnesota | MN |
| Mississippi | MO |
| Missouri | MS |
| Montana | MT |
Well, so much for that theory. If that was what screwed it up, Maryland, Michigan, Minnesota, and Montana would be right, and Maine, Massachusetts, Mississippi and Missouri would be wrong.
| The way rotohog has it now | |
| state chosen | get cities from |
| Maine | Massachusetts |
| Maryland | Maryland |
| Massachusetts | Maine |
| Michigan | Michigan |
| Minnesota | Missouri |
| Mississippi | Minnesota |
| Missouri | Mississippi |
| Montana | Montana |
I don’t see the pattern. Do you?
(Side note: I’m going to be playing a fantasy team on Rotohog this year. Rotohog has a pretty good plan: market-based values for players, and you hold them like stocks, waiting for their values to rise and fall, but they’re always paying dividends based on their game performance. It’s not exactly like HSX, though: there is a limit to one of each player per 12 managers in the game, so actual scarcity does interesting things with demand.)
