All pastes #387835 Raw Edit

Mine

public text v1 · immutable
·published 2007-03-09 18:01 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,7 @@

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