The Aural Moon "FLAG PROJECT"

[Yesspaz]

Okay, not to be TOO nitpicky, but let's check with what's already done before doing more. Some are getting redone and changed from correct to incorrect. Also, be careful in spelling and punctuation. These are cut and paste from the master list above:

UPDATE samdb.songlist set lyrics="US" where artist="Album Leaf, The";
UPDATE samdb.songlist set lyrics="IS" where artist="Album Leaf, The";

and

UPDATE samdb.songlist set lyrics="AU" where artist="Allen, Daevid";
UPDATE samdb.songlist set lyrics="US" where artist="Allen, David";

and

UPDATE samdb.songlist set lyrics="GB" where artist="Anderson, Bruford, Wakeman, Howe";
UPDATE samdb.songlist set lyrics="UK" where artist="Anderson, Bruford, Wakeman, Howe";
UPDATE samdb.songlist set lyrics="UK" where artist="Anderson, Ian ";
UPDATE samdb.songlist set lyrics="GB" where artist="Anderson, Ian";
UPDATE samdb.songlist set lyrics="US" where artist="Anderson, Jon";
UPDATE samdb.songlist set lyrics="GB" where artist="Anderson, Jon";
UPDATE samdb.songlist set lyrics="US" where artist="Anderson, Laurie";
UPDATE samdb.songlist set lyrics="UK" where artist="Anderson, Laurie";

and

UPDATE samdb.songlist set lyrics="US" where artist="dc Talk";
UPDATE samdb.songlist set lyrics="US" where artist="dcTalk";

and

UPDATE samdb.songlist set lyrics="AU" where artist="Ilium";
UPDATE samdb.songlist set lyrics="US" where artist="Ilium";

and

UPDATE samdb.songlist set lyrics="GB" where artist="Iommi, Tommy";
UPDATE samdb.songlist set lyrics="UK" where artist="Iommi, Tommy";
UPDATE samdb.songlist set lyrics="UK" where artist="Iona";
UPDATE samdb.songlist set lyrics="GB" where artist="Iona";



... for the record, The Album Leaf and Ilium are both US bands.

[VAXman(Admin)]

Originally Posted by Yesspaz

Okay, not to be TOO nitpicky, but let's check with what's already done before doing more. Some are getting redone and changed from correct to incorrect. Also, be careful in spelling and punctuation. These are cut and paste from the master list above:

UPDATE samdb.songlist set lyrics="US" where artist="Album Leaf, The";
UPDATE samdb.songlist set lyrics="IS" where artist="Album Leaf, The";

and

UPDATE samdb.songlist set lyrics="AU" where artist="Allen, Daevid";
UPDATE samdb.songlist set lyrics="US" where artist="Allen, David";

and

UPDATE samdb.songlist set lyrics="GB" where artist="Anderson, Bruford, Wakeman, Howe";
UPDATE samdb.songlist set lyrics="UK" where artist="Anderson, Bruford, Wakeman, Howe";
UPDATE samdb.songlist set lyrics="UK" where artist="Anderson, Ian ";
UPDATE samdb.songlist set lyrics="GB" where artist="Anderson, Ian";
UPDATE samdb.songlist set lyrics="US" where artist="Anderson, Jon";
UPDATE samdb.songlist set lyrics="GB" where artist="Anderson, Jon";
UPDATE samdb.songlist set lyrics="US" where artist="Anderson, Laurie";
UPDATE samdb.songlist set lyrics="UK" where artist="Anderson, Laurie";

and

UPDATE samdb.songlist set lyrics="US" where artist="dc Talk";
UPDATE samdb.songlist set lyrics="US" where artist="dcTalk";

and

UPDATE samdb.songlist set lyrics="AU" where artist="Ilium";
UPDATE samdb.songlist set lyrics="US" where artist="Ilium";

and

UPDATE samdb.songlist set lyrics="GB" where artist="Iommi, Tommy";
UPDATE samdb.songlist set lyrics="UK" where artist="Iommi, Tommy";
UPDATE samdb.songlist set lyrics="UK" where artist="Iona";
UPDATE samdb.songlist set lyrics="GB" where artist="Iona";



... for the record, The Album Leaf and Ilium are both US bands.

Hmm... It would appear that the sort/merge on Linux isn't as good as the sort/merge on VMS. I have been sorting on column 52 through the end and I've requested the removal of duplicates. Apparently, this is not happening. I'll be sure to sort/merge this on the better OS in the future.

"dc Talk/dcTalk" is in SAM's database that way. If you want to correct that, please do so with SAM. I think you still have station access.

"UK" should be "GB", I'll fix those. I've addressed the "Andersons" too.