All pastes #387795 Raw Edit

Stuff

public text v1 · immutable
#387795 ·published 2007-03-09 17:21 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(path, '/', filename) AS filename FROM music_songs s, music_directories d WHERE s.directory_id=d.directory_id AND song_id = :KEY" );
             query.bindValue(":KEY", nTrack );
             query.exec();