mpserviceplugins/mpxsqlitepodcastdbplugin/src/mpxdbcategory.cpp
changeset 25 3ec52facab4d
parent 19 4e84c994a771
--- a/mpserviceplugins/mpxsqlitepodcastdbplugin/src/mpxdbcategory.cpp	Mon May 03 12:29:20 2010 +0300
+++ b/mpserviceplugins/mpxsqlitepodcastdbplugin/src/mpxdbcategory.cpp	Fri May 14 15:49:53 2010 +0300
@@ -588,13 +588,17 @@
         iDbManager.ExecuteSelectQueryL(aDriveId, *query, aId));
     CleanupClosePushL(recordset);
 
-    if (recordset.Next() != KSqlAtRow)
+    TInt err(KSqlAtEnd);
+    TInt ret(0) ;
+    while((err = recordset.Next()) == KSqlAtRow)
+        {
+        ret += recordset.ColumnInt(KMPXTableDefaultIndex);
+        }
+    if(err != KSqlAtEnd)
         {
         User::Leave(KErrNotFound);
         }
-
-    TInt ret = recordset.ColumnInt(KMPXTableDefaultIndex);
-
+    MPX_DEBUG2("CMPXDbCategory::GetEpisodeCountL Count %d" , ret);
     CleanupStack::PopAndDestroy(&recordset);
     CleanupStack::PopAndDestroy(query);