--- a/mpserviceplugins/mpxsqlitepodcastdbplugin/src/mpxdbcategory.cpp Mon May 03 12:29:20 2010 +0300
+++ b/mpserviceplugins/mpxsqlitepodcastdbplugin/src/mpxdbcategory.cpp Fri Apr 30 19:33:32 2010 -0500
@@ -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);