[Mp-plugins-svn] SF.net SVN: mp-plugins: [641] trunk/plugins/myGUIProgramsAlt/GUIProgramsAlt /FileItems/FilelinkList.cs

[<nor...@us...>]

Revision: 641
          http://mp-plugins.svn.sourceforge.net/mp-plugins/?rev=641&view=rev
Author:   northern_sky
Date:     2007-06-26 12:02:52 -0700 (Tue, 26 Jun 2007)

Log Message:
-----------
query working again (i hope=)

Modified Paths:
--------------
    trunk/plugins/myGUIProgramsAlt/GUIProgramsAlt/FileItems/FilelinkList.cs

Modified: trunk/plugins/myGUIProgramsAlt/GUIProgramsAlt/FileItems/FilelinkList.cs
===================================================================
--- trunk/plugins/myGUIProgramsAlt/GUIProgramsAlt/FileItems/FilelinkList.cs	2007-06-26 13:28:59 UTC (rev 640)
+++ trunk/plugins/myGUIProgramsAlt/GUIProgramsAlt/FileItems/FilelinkList.cs	2007-06-26 19:02:52 UTC (rev 641)
@@ -75,7 +75,7 @@
       if (sqlDB == null)
         return;
       try
-      {
+      { 
         Clear();
         if (null == sqlDB)
           return;
@@ -84,9 +84,43 @@
         // filePath = strPath;
         // applicationItem.
         // SPECIAL: the current application IS NOT the application with the launchinfo!
-        strSQL = String.Format(
-           "SELECT fi.appid AS targetappid, fi.grouperappid AS grouperappid, f.fileid AS fileid, title, uppertitle, f.filename as filename, imagefile, mainGenre, subGenre, country, manufacturer, YEAR, rating, overview, SYSTEM, import_flag, manualfilename, lasttimelaunched, launchcount, isfolder, external_id FROM tblFileItem f, tblFilterItem fi WHERE f.fileid = fi.fileid AND grouperappid = {0} ORDER BY fileName, uppertitle", nAppID);
-          results = sqlDB.Execute(strSQL);
+        strSQL =@"
+          SELECT 
+            fi.appid AS targetAppId,
+            fi.grouperAppId AS grouperAppId,
+            f.fileId AS fileId, 
+            title,
+            upperTitle,
+            f.filename AS filename, 
+            imagefile,
+            mainGenre,
+            subGenre,
+            country, 
+            manufacturer,
+            year,
+            rating,
+            overview,
+            system,
+            import_flag,
+            manualFilename,
+            lastTimeLaunched,
+            launchCount,
+            isFolder,
+            external_id 
+
+        FROM 
+          tblFileItem f,
+          tblFilterItem fi 
+      
+       WHERE 
+          f.fileId = fi.fileId 
+         AND 
+          grouperAppId = " + nAppID + @"
+
+      ORDER BY f.fileName, uppertitle
+      ";
+
+        results = sqlDB.Execute(strSQL);
         if (results.Rows.Count == 0)
           return;
         for (int iRow = 0; iRow < results.Rows.Count; iRow++)


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.