judas wrote:@trixmoto, thanks for the prompt reply, the message I get after changing the above mentioned lines is:
- Code: Select all
There Was a problem querying the database:
Error executing SQL UPDATE Artists SET Artists.Artist = 'SIDESTEPPER' WHERE Artists.Artist = 'SIDESTEPPER'
"near: ".":.syntax error (1,1)
And I have NO idea as to what that means

Hi Folks,
I am trying to use the CASE change version of this script (the one dated internally as 2007-07-27
I am getting the same error Judas reported.
I have tried changing the code as Judas was instructed to do, but the error continues, it just changed slightly due to my code change.
I was getting:
- Code: Select all
There Was a problem querying the database:
Error executing SQL "UPDATE Artists SET Artists.Artist = 'Loop Guru' WHERE Artists.Artist = 'Loop Guru'"near: ".":.syntax error (1,1)
I changed the code from the first version here to the next one:
- Code: Select all
sql = "UPDATE Artists SET Artists.Artist = " & SQLQStr(str) & " WHERE Artists.Artist=" & SQLQStr(Itm.ArtistName)
sql = "UPDATE Artists SET Artist = " & SQLQStr(str) & " WHERE Artists = " & SQLQStr(Itm.ArtistName)
But this did not fix it. Error just now says:
- Code: Select all
There Was a problem querying the database:
Error executing SQL "UPDATE Artists SET Artist = 'Loop Guru' WHERE Artist = 'Loop Guru'": no such column: Artists (1,1)
There were two locations where I made this change, the second just a 10 or 15 lines below the first. In my file they are lines 493 and 509
Any ideas how I can fix this would be greatly appreciated.
This is one of my most time-saving scripts, so I'd love to get it working.
Thanks,
Jonathan