3
« on: April 30, 2018, 10:05:17 pm »
Hi Ivek:
The problem is in the spaces and line feeds they put between elements. Also the <p> now comes before the <span itemprop="description" part, not after like before (I found and old page I had saved and saw the differences. I changed the description code to this:
//~Description~
curPos := Pos('<h2>Storyline</h2>', HTML)
If Pos('<h2>Storyline</h2>', HTML) > 0 then begin
EndPos := PosFrom('<span itemprop="description">', HTML,curPos);
//curPos := PosFrom('<p>', HTML, EndPos);
curPos := curPos + Length('<span itemprop="description">');
EndPos := PosFrom('<em class="nobr">', HTML, curPos);
TmpStr00 := RemoveTags(Trim(Copy(HTML, curPos, endPos - curPos)), false);
if TmpStr00 <> '' then AddFieldValueXML('description', TmpStr00);
end;
The sql command I used was:
UPDATE MOVIES SET "description"='' WHERE "mid"=4946
where 4946 was the id of the movie corrupted.
But I don't know exactly how to do it inside the program,in my case just as I opened PVD it hanged, so I had to use an external database program: I connected to the movies database with odbc, and sent the command. If someone can't open the program that it hangs, and has a database under 2gb, he could send it to me with wetransfer and I could clean that description.