[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