[mythtv] Removing scheduled recordings

[Joseph A. Caputo]

On Wednesday 28 May 2003 09:55 pm, Chris Pinkham wrote:
> > Okay, I've re-synched the patch.  It's as follows:
>
> Looks OK but I'm not sure about this one.  Have you tested this?
>
> > '2':
> > Flag this showing as a duplicate, even if it's not in the oldrecorded
> > table
>
> I didn't apply the patch but I'm not seeing the part of the sql query
> like this:
>
> 	oldrecorded.starttime IS NOT NULL AS duplicate
>
> could return a 1 if there aren't any oldrecorded records and the leftjoin
> is true because of the last part of your where clause of
>
> 	program.overridesuppression = 2
>
> Just curious if this was tested and works.  If you say so then I'll
> apply it to my tree and see about getting it in CVS with a UI to edit
> the fields sometime.
>
> Chris


Hmmm... seems like a valid point; I'm certainly no SQL expert.  All I can say 
is that I've tested it & it seems to work as advertised.  It does seem odd, 
though... think I'll do a little reading on JOINs and see why this works in 
spite of itself :-)

-JAC