<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I am trying to figure out how to determine the hdtv status
of a recording. The recorded table does not seem to contain this
information. It is available in the recordedprogram table but that table
appears to include both current recordings as well as previous recordings.
While it might seem that I could just join the recorded table to the
recordedprogram table, I can’t figure out a foolproof way to do
that. I thought about joining on the chanid, starttime, and programid
fields but it turns out that the starttime in recorded is, apparently, the
start time of the recording whereas the starttime in recordedprogram is the
scheduled start time. Though, I suppose I could fudge something using an
approximate range of times, besides getting messy it is a little less precise
than I would prefer – I want this for a custom recording rule so it would
be best that the query runs as quickly as possible. It seems odd to me
that there is not some direct link between the recordedprogram table and the
recorded table since, I presume, there is a direct logical link between the two
(I presume that recorded refers to the actual physical recording and
recordedprogram refers to a program which has been recorded, and therefore, at
least until the recording is deleted, that recordedprogram entry directly corresponds
to an entry in the recorded table). Can anyone help me out with this?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Also, what does recordedprogram contain for a recording
which is split? For example, if the machine is rebooted while a recording
is in progress, upon coming back up the recording resumes as a second recording
– I presume that there are two entries in the recorded table in such a
case. Is there still only one in recordedprogram?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Thanks.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>- Les<o:p></o:p></span></font></p>
</div>
</body>
</html>