diff -r ecf06a08d4d9 -r 3ec52facab4d mpserviceplugins/mpxsqlitepodcastdbplugin/src/mpxdbcategory.cpp --- 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);