On Thu, Oct 7, 2010 at 23:35, Dan McGee <[email protected]> wrote: > On Wed, Oct 6, 2010 at 4:05 AM, Roman Kyrylych <[email protected]> > wrote: >> 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. > > No, *new* ones would have to be entered correctly after we fix the > *existing* ones.
Looks like we were talking about the same thing. :) > We can make it a select box if you want Nah, no need for that, I can just enter them properly. -- Roman Kyrylych (Роман Кирилич)
