Get the artist of a song in SQL

[m0nkiii]

I'm going to update the PlayCounter of some songs and I have the following code:

Code: Select all

SDB.Database.ExecSQL( "UPDATE Songs SET PlayCounter= WHATEVER WHERE (Songs.SongTitle = WHATEVER and Songs.Artist = WHATEVER)")

But Songs.Artist won't work. Neither will Songs.ArtistName etc...
Help...

[Bex]

Try this:

Code: Select all

SDB.Database.ExecSQL("UPDATE Songs INNER JOIN Artists ON Songs.IDArtist = Artists.ID SET Songs.PlayCounter = SomeNumber WHERE Songs.SongTitle = 'SomeTitle' AND Artists.Artist = 'SomeArtist' ")

The Artist name is store in the Artists table and not in the Songs table so you need to link the songs table to the Artists table. And don't forget to enclose text values with -> '

[m0nkiii]

Gött mos, Spanks !

I thought it was something like that but I couldn't get it to work