mpxplugins/serviceplugins/collectionplugins/mpxsqlitepodcastdbplugin/src/mpxdbcategory.cpp
branchRCL_3
changeset 14 c54d95799c80
parent 0 ff3acec5bc43
--- a/mpxplugins/serviceplugins/collectionplugins/mpxsqlitepodcastdbplugin/src/mpxdbcategory.cpp	Wed Mar 31 21:26:33 2010 +0300
+++ b/mpxplugins/serviceplugins/collectionplugins/mpxsqlitepodcastdbplugin/src/mpxdbcategory.cpp	Wed Apr 14 15:54:18 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);