How to get SDBSongData from a path
Posted: Sat Oct 17, 2009 5:25 am
Say I have any given path, how do I get it's SDBSongData object only if it is in the database?
I've not got the code on me write now but my "Recreate M3U" script does this. The SQL for QuerySongs is something like...
"AND Songs.Path = ':\Music\Artist\Album\Track.mp3' "
...or you can use LIKE if you only have part of it. The path does not include the drive letter though, this is stored in a separate table.