Escaping needed in EIT DB queries

[otto at kolsi dot fi]

If EIT data contains ' -characters, DB queries fail because those characters brake the query if not escaped.

Following shows an example where year is present with text 79':

2009-01-06 09:02:16.591 MSqlQuery::exec() "REPLACE INTO program (
chanid, title, subtitle, description, category, category_type,
starttime, endtime, closecaptioned, stereo, hdtv, subtitled,
subtitletypes, audioprop, videoprop, partnumber, parttotal,
syndicatedepisodenumber, airdate, originalairdate, listingsource,
seriesid, programid, previouslyshown)
VALUES ('1007', 'Jäähyväiset aseille', '',
'(A Farewell to Arms/USA 1932, 79') Ernest Hemingwayn romaaniin
perustuva rakkauselokuva sotilaasta ja sairaanhoitajattaresta
ensimmäisessä maailmansodassa. O: Frank Borzage. N: Gary Cooper,
Helen Hayes, Adolphe Menjou.', 'Movie', 'movie',
'2009-01-06T14:04:49', '2009-01-06T15:25:01', 'false',
'false', 'false', 'false', '0', '0', '0', '0', '0', '',
'0000', '', '1', '', '', 'false')"

[otto at kolsi dot fi]

This should be closed as invalid. There's something going on with EIT and overlapping programs. But once the details are clear, that should go to it's own ticket.