All pastes #387932 Raw Edit

Stuff

public text v1 · immutable
#387932 ·published 2007-03-09 18:47 UTC
rendered paste body
Index: mythtv/programs/mythbackend/httpstatus.cpp
===================================================================
--- mythtv/programs/mythbackend/httpstatus.cpp  (revision 12978)
+++ mythtv/programs/mythbackend/httpstatus.cpp  (working copy)
@@ -1120,7 +1120,11 @@

         if (query.isConnected())
         {
-            query.prepare("SELECT filename FROM music_songs WHERE song_id = :KEY" );
+            query.prepare("SELECT CONCAT_WS('/', music_directories.path, "
+            "music_songs.filename) AS filename FROM music_songs "
+            "LEFT JOIN music_directories ON "
+            "music_songs.directory_id=music_directories.directory_id "
+            "WHERE music_songs.song_id = :KEY");
             query.bindValue(":KEY", nTrack );
             query.exec();