diff -r 08733234ccb1 -r 7bca37ba5fa9 engine/src/ShowEngine.cpp --- a/engine/src/ShowEngine.cpp Sun Feb 28 23:25:24 2010 +0000 +++ b/engine/src/ShowEngine.cpp Mon Mar 01 22:57:56 2010 +0000 @@ -808,15 +808,28 @@ { DP1("CShowEngine::DBUpdateShow, title='%S'", &aItem.Title()); + HBufC* titleBuf = HBufC::NewLC(KMaxLineLength); + TPtr titlePtr(titleBuf->Des()); + titlePtr.Copy(aItem.Title()); + PodcastUtils::SQLEncode(titlePtr); + + HBufC* descBuf = HBufC::NewLC(KMaxLineLength); + TPtr descPtr(descBuf->Des()); + descPtr.Copy(aItem.Description()); + PodcastUtils::SQLEncode(descPtr); + _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\" where uid=\"%u\""); - iSqlBuffer.Format(KSqlStatement, &aItem.Url(), &aItem.Title(), &aItem.Description(), + iSqlBuffer.Format(KSqlStatement, &aItem.Url(), &titlePtr, &descPtr, &aItem.FileName(), aItem.Position().Int64(), aItem.PlayTime(), aItem.PlayState(), aItem.DownloadState(), aItem.FeedUid(), aItem.ShowSize(), aItem.TrackNo(), aItem.PubDate().Int64(), aItem.ShowType(), aItem.LastError(), aItem.Uid()); + CleanupStack::PopAndDestroy(descBuf); + CleanupStack::PopAndDestroy(titleBuf); + sqlite3_stmt *st; int rc = sqlite3_prepare16_v2(&iDB, (const void*) iSqlBuffer.PtrZ(), -1,