Details
Description
When retrieving artist info from the database the wrong results can be returned.
We are looking for artist info where the artist name starts with the artist we are looking for so if we are looking for Gun but have Guns n Roses in the database then this can be returned instead
h4. Additional Information
Code in GetArtistInfo in MusicDatabaseLookups.cs is
strSQL = String.Format("select * from artistinfo where strArtist like '{0}%'", strArtist);
presumably this is in an attempt to be case insensitive
we then pick first match (which can be different to the one we want)
We are looking for artist info where the artist name starts with the artist we are looking for so if we are looking for Gun but have Guns n Roses in the database then this can be returned instead
h4. Additional Information
Code in GetArtistInfo in MusicDatabaseLookups.cs is
strSQL = String.Format("select * from artistinfo where strArtist like '{0}%'", strArtist);
presumably this is in an attempt to be case insensitive
we then pick first match (which can be different to the one we want)
Attachments
Issue Links
- links to