| changeset 77 | 6284a24658d6 |
| parent 67 | 9c24c921ec35 |
| child 84 | fbb6c20a24b5 |
| 73:4abf603ec3e6 | 77:6284a24658d6 |
|---|---|
361 HBufC* descBuf = HBufC::NewLC(KMaxLineLength); |
361 HBufC* descBuf = HBufC::NewLC(KMaxLineLength); |
362 TPtr descPtr(descBuf->Des()); |
362 TPtr descPtr(descBuf->Des()); |
363 descPtr.Copy(aItem.Description()); |
363 descPtr.Copy(aItem.Description()); |
364 PodcastUtils::SQLEncode(descPtr); |
364 PodcastUtils::SQLEncode(descPtr); |
365 |
365 |
366 _LIT(KSqlStatement, "insert into feeds (url, title, description, imageurl, imagefile, link, built, lastupdated, uid, feedtype, customtitle, lasterror)" |
366 _LIT(KSqlStatement, "insert into feeds (url, title, description, imageurl, imagefile, link, built, lastupdated, uid, feedtype, customtitle, lasterror) values (\"%S\",\"%S\", \"%S\", \"%S\", \"%S\", \"%S\", \"%Ld\", \"%Ld\", \"%u\", \"%u\", \"%u\", \"%d\")"); |
367 " values (\"%S\",\"%S\", \"%S\", \"%S\", \"%S\", \"%S\", \"%Ld\", \"%Ld\", \"%u\", \"%u\", \"%u\", \"%d\")"); |
|
368 iSqlBuffer.Format(KSqlStatement, |
367 iSqlBuffer.Format(KSqlStatement, |
369 &aItem.Url(), titleBuf, descBuf, &aItem.ImageUrl(), &aItem.ImageFileName(), &aItem.Link(), |
368 &aItem.Url(), titleBuf, descBuf, &aItem.ImageUrl(), &aItem.ImageFileName(), &aItem.Link(), |
370 aItem.BuildDate().Int64(), aItem.LastUpdated().Int64(), aItem.Uid(), EAudioPodcast, aItem.CustomTitle(), aItem.LastError()); |
369 aItem.BuildDate().Int64(), aItem.LastUpdated().Int64(), aItem.Uid(), EAudioPodcast, aItem.CustomTitle(), aItem.LastError()); |
371 |
370 |
372 CleanupStack::PopAndDestroy(descBuf); |
371 CleanupStack::PopAndDestroy(descBuf); |
474 HBufC* descBuf = HBufC::NewLC(KMaxLineLength); |
473 HBufC* descBuf = HBufC::NewLC(KMaxLineLength); |
475 TPtr descPtr(descBuf->Des()); |
474 TPtr descPtr(descBuf->Des()); |
476 descPtr.Copy(aItem.Description()); |
475 descPtr.Copy(aItem.Description()); |
477 PodcastUtils::SQLEncode(descPtr); |
476 PodcastUtils::SQLEncode(descPtr); |
478 |
477 |
479 _LIT(KSqlStatement, "update feeds set url=\"%S\", title=\"%S\", description=\"%S\", imageurl=\"%S\", imagefile=\"%S\"," \ |
478 _LIT(KSqlStatement, "update feeds set url=\"%S\", title=\"%S\", description=\"%S\", imageurl=\"%S\", imagefile=\"%S\",link=\"%S\", built=\"%Lu\", lastupdated=\"%Lu\", feedtype=\"%u\", customtitle=\"%u\", lasterror=\"%d\" where uid=\"%u\""); |
480 "link=\"%S\", built=\"%Lu\", lastupdated=\"%Lu\", feedtype=\"%u\", customtitle=\"%u\", lasterror=\"%d\" where uid=\"%u\""); |
|
481 iSqlBuffer.Format(KSqlStatement, |
479 iSqlBuffer.Format(KSqlStatement, |
482 &aItem.Url(), titleBuf, descBuf, &aItem.ImageUrl(), &aItem.ImageFileName(), &aItem.Link(), |
480 &aItem.Url(), titleBuf, descBuf, &aItem.ImageUrl(), &aItem.ImageFileName(), &aItem.Link(), |
483 aItem.BuildDate().Int64(), aItem.LastUpdated().Int64(), EAudioPodcast, aItem.CustomTitle(), aItem.LastError(), aItem.Uid()); |
481 aItem.BuildDate().Int64(), aItem.LastUpdated().Int64(), EAudioPodcast, aItem.CustomTitle(), aItem.LastError(), aItem.Uid()); |
484 |
482 |
485 CleanupStack::PopAndDestroy(descBuf); |
483 CleanupStack::PopAndDestroy(descBuf); |