[mythtv-users] what is mythcommflag doing?

[Harry Orenstein]

>From: Cedar McKay <cedar at aliandcedar.com>
>Reply-To: Discussion about mythtv <mythtv-users at mythtv.org>
>To: Discussion about mythtv <mythtv-users at mythtv.org>
>Subject: Re: [mythtv-users] what is mythcommflag doing?
>Date: Sat, 22 Nov 2003 02:59:29 -0800
>
>>
>>Change "WHERE chanid" to "WHERE record.chanid" and see if that works.
>
>I think you got it. But instead of changing it to "record.chanid", I  
>changed it to "recorded.chanid". If I did that, this was the output:
>
>mysql> SELECT  
>recorded.chanid,starttime,endtime,title,subtitle,description,channel.cha 
>nnum,channel.callsign,channel.name
>     -> FROM recorded
>     -> LEFT JOIN channel ON recorded.chanid = channel.chanid
>     -> WHERE recorded.chanid = 1009
>     -> AND starttime = 20030419200000;
>+--------+----------------+----------------+----------+---------- 
>+---------------------------------+---------+----------+------+
>| chanid | starttime      | endtime        | title    | subtitle |  
>description                     | channum | callsign | name |
>+--------+----------------+----------------+----------+---------- 
>+---------------------------------+---------+----------+------+
>|   1009 | 20030419200000 | 20030419203000 | Mr. Bean | Mr. Bean | An  
>exam; sneezing; swim trunks. | NULL    | NULL     | NULL |
>+--------+----------------+----------------+----------+---------- 
>+---------------------------------+---------+----------+------+
>1 row in set (0.01 sec)
>
>
>I notice that the channum, callsign, and name all show up as NULL, but  I 
>doubt that matters.
>
>thanks for your help,
>Cedar
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

I don't know if anyone is interested, but there is an alternate
syntax that may be easier to use.  Try:

select r.chanid,starttime,endtime,title,subtitle,description,
channum,callsign,name from recorded r, channel c
where r.chanid = 1009 and starttime = 20030419200000 and
r.chanid = c.chanid;

I am more used to Oracle SQL, so to do an outer join I would
have to do a little more research.

Hope this helps (maybe someone else)!!


-- Harry O.

_________________________________________________________________
Is there a gadget-lover on your gift list?  MSN Shopping has lined up some 
good bets!  http://shopping.msn.com