On Fri, Oct 1, 2010 at 18:56, Dan McGee <[email protected]> wrote: > On Fri, Oct 1, 2010 at 10:53 AM, Roman Kyrylych > <[email protected]> wrote: >> On Fri, Oct 1, 2010 at 18:02, Dan McGee <[email protected]> wrote: >>> If there is something in here that is wrong, let's just write some SQL >>> to fix it up: >>> >>> UPDATE mirrors_mirror SET country = 'Best Country Ever!' WHERE country >>> = 'Germany'; >>> >>> If you can put together mappings like this to get the names adjusted >>> to whatever that ISO standard # was, we'll be in business. >> >> I guess the most popular will be >> UPDATE mirrors_mirror SET country = 'United Kindgom' WHERE country = >> 'Great Britain'; >> but my question is: >> since I don't see a dropdown list for selecting a country >> but have to enter it manually each time I add a new mirror >> will I have to rewrite the Country fileld for existing mirrors >> after each country name change? > > Are you missing what this does? The SQL is to rewrite all existing > mirrors using those country names, it has nothing to do with new ones.
That's exactly what my intention was. I am missing your point. Existing ones would just have to be entered correctly. Or do you want to change the field in the admin GUI from text input to selectbox? -- Roman Kyrylych (Роман Кирилич)
