926 HBufC* descBuf = HBufC::NewLC(KMaxLineLength); |
926 HBufC* descBuf = HBufC::NewLC(KMaxLineLength); |
927 TPtr descPtr(descBuf->Des()); |
927 TPtr descPtr(descBuf->Des()); |
928 descPtr.Copy(aItem.Description()); |
928 descPtr.Copy(aItem.Description()); |
929 PodcastUtils::SQLEncode(descPtr); |
929 PodcastUtils::SQLEncode(descPtr); |
930 |
930 |
931 _LIT(KSqlStatement, "update shows set url=\"%S\", title=\"%S\", description=\"%S\", filename=\"%S\", position=\"%Lu\", playtime=\"%u\", playstate=\"%u\", downloadstate=\"%u\", feeduid=\"%u\", showsize=\"%u\", trackno=\"%u\",pubdate=\"%Lu\", showtype=\"%d\", lasterror=\"%d\",deletedate=\"%Lu\" where uid=\"%u\""); |
931 _LIT(KSqlStatement, "update shows set url=\"%S\", title=\"%S\", description=\"%S\", filename=\"%S\", position=\"%Lu\", playtime=\"%u\", playstate=\"%u\", downloadstate=\"%u\", feeduid=\"%u\", showsize=\"%u\", trackno=\"%u\",pubdate=\"%Lu\", showtype=\"%d\", lasterror=\"%d\", deletedate=\"%Lu\" where uid=\"%u\""); |
932 iSqlBuffer.Format(KSqlStatement, &aItem.Url(), &titlePtr, &descPtr, |
932 iSqlBuffer.Format(KSqlStatement, &aItem.Url(), &titlePtr, &descPtr, |
933 &aItem.FileName(), aItem.Position().Int64(), aItem.PlayTime(), |
933 &aItem.FileName(), aItem.Position().Int64(), aItem.PlayTime(), |
934 aItem.PlayState(), aItem.DownloadState(), aItem.FeedUid(), |
934 aItem.PlayState(), aItem.DownloadState(), aItem.FeedUid(), |
935 aItem.ShowSize(), aItem.TrackNo(), aItem.PubDate().Int64(), |
935 aItem.ShowSize(), aItem.TrackNo(), aItem.PubDate().Int64(), |
936 aItem.ShowType(), aItem.LastError(), aItem.Uid(), aItem.DeleteDate()); |
936 aItem.ShowType(), aItem.LastError(), aItem.DeleteDate(), aItem.Uid()); |
937 |
937 |
938 CleanupStack::PopAndDestroy(descBuf); |
938 CleanupStack::PopAndDestroy(descBuf); |
939 CleanupStack::PopAndDestroy(titleBuf); |
939 CleanupStack::PopAndDestroy(titleBuf); |
940 |
940 |
941 sqlite3_stmt *st; |
941 sqlite3_stmt *st; |