Tutorial to MediaMonkey, anyone?

[almo9004]

@ trixmoto:
Sorry man, it doesn't work.
I'm getting the exact same error as before.

I think we are gonna need some serious help from the pros...

[trixmoto]

Oh yes, to reference GenreName you need to do a JOIN with the Genre table but you can't do that in the WHERE statement. You might need to do an OpenSql with...

Code: Select all

SELECT Songs.ID FROM Genres INNER JOIN Songs ON Genres.IDGenre = Songs.Genre WHERE Genres.GenreName LIKE 'Pop'

Hopefully someone has a way for you to do it with the QuerySongs if this is not helpful to you.

[trixmoto]

Actually I think Pop is always 13 so you could try...

Code: Select all

SDB.Database.QuerySongs("AND Genre=13")

[Bex]

First of all. Trixi is a pro! Bigtime!

This also works if you must use SDB.Database.QuerySongs:

Code: Select all

SDB.Database.QuerySongs("AND Genre in (Select IDGenre From Genres Where GenreName  = 'Pop')")

But is a bit slower than "= 13" due to the inline.

/Bex

[almo9004]

@ Bex:
Yey, your suggestion worked and it was a quite simple solution, even if most of it is greek to me.

@ Trixmoto:
I hope I didn't hurt you with my unsensitive behaviour and possible assault.
I'm working on your suggestion, but I seem to run into some problems. As far as I know, it returns an SDBDBIterator from which you can extract the (record) index of the song.
But how do I turn the numbers into songs?

Thank you all for your responds, you have helped me greatly!

[trixmoto]

Yes, my solution is not ideal as you then need to do a QuerySongs using each ID to get each song, which is obviously slower. I was not offended by your comments, SQL is not my strong point. Bex's solution is the best, he's an SQL guru!