[mythtv] FIX "do not autoexpire" Flag made persistent
Bruce Markey
bjm at lvcm.com
Mon Oct 4 20:05:38 UTC 2004
Marcel Meier wrote:
...
> I made changes to the following function: "ProgramInfo::AllowRecordingNewEpisodes" in the "libmythtv" directory
> 1) read not count but autoexpire flag for the recorded episodes
> /*query.prepare("SELECT count(*) FROM recorded WHERE title = :TITLE;"); original line*/
> query.prepare("SELECT autoexpire FROM recorded WHERE title = :TITLE;");
That's not what you want. That would return multiple rows
with a 0 or 1 for autoexpire from each matching row.
query.prepare("SELECT count(*) FROM recorded "
"WHERE title = :TITLE AND autoexpire > 0;");
Returns one result for the number of items that match the title
and have a greater than zero value for autoexpire.
-- bjm
More information about the mythtv-dev
mailing list