[mythtv-users] what is mythcommflag doing?
Chris Pinkham
cpinkham at bc2va.org
Fri Nov 21 18:53:15 EST 2003
> >Try running the following query:
> >
> >SELECT recorded.chanid,starttime,endtime,title,subtitle,
> > description,channel.channum,channel.callsign,
> > channel.name
> > FROM recorded,channel
> > WHERE recorded.chanid = 1009
> > AND starttime = 20030419200000
> > AND recorded.chanid = channel.chanid;
> >
> >That's the query that gets run to check to retrieve program info from
> >the DB when you're running mythcommflag.
> Hmm. I don't really understand this. If I do it exactly as you have
> written I get an empty set. But why do you want me to do the
> AND recorded.chanid = channel.chanid;
> line?
Try running this query instead and see if it returns any rows:
SELECT recorded.chanid,starttime,endtime,title,subtitle,
description,channel.channum,channel.callsign,
channel.name
FROM recorded
LEFT JOIN channel ON recorded.chanid = channel.chanid
WHERE chanid = 1009
AND starttime = 20030419200000;
--
Chris
More information about the mythtv-users
mailing list