Good point. I think I found a suitable column in the recorded table to sort on: originalairdate. <br><br>Problem is that the nuvexport script quesies the database and stuffs all that data into a hash table. Then, it sorts that hash table by start_date and channel, I believe.
<br><br>I guess I'll have to go learn some perl unless someone here would like to offer a suggestion on how to modify the script to sort the hash table by the originalairdate :)<br><br><div><span class="gmail_quote">On 1/2/06,
<b class="gmail_sendername">Bruce Markey</b> <<a href="mailto:bjm@lvcm.com">bjm@lvcm.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Larry K wrote:<br>> Can anyone explain the difference between the Recorded and the<br>> Recordedprogram tables in Mythtv 0.18? In my system, the Recorded table<br>> has 8 more rows than the Recordedprogram table (8 out of 151).
<br><br>Recorded is predates the other and is the information about a<br>recorded file and the attributes of that recording, some of which<br>are not from 'program'. Recordedprogram was added later to copy the<br>info from the program table for the show so that these fields would
<br>be available for the Program Details page. You may have some recordings<br>made before this was added.<br><br>> The reason I ask is that I want to modify my nuvexport script to sort<br>> the results by the syndicatedepsidodenumber column when I choose a show
<br><br>Had you looked at many of these, the producers schemes for labeling<br>are all over the map, include letters, need to be sorted as strings<br>that may not be in sequential order and often aren't present at all.<br>
TMS programids are in a standard format, always present, always<br>unique and will sort sequentially.<br><br>> title to get all the subtitle (episode) detail information. Right now,<br>> the script queries the recorded table and the rows are returned in the
<br>> order they were inserted into the table. The Recorded table does not<br>> have the syndicatedepsidodenumber column, whereas the Recordedpropgram<br>> table does. As I was about to modify the script I realized that the
<br>> Recordedpropgram table seems to be missing some entries that are present<br>> in the Recorded table, so this may foil my plan.<br><br>Query both to try to get what you need. If there isn't an entry in<br>recordedprogram then, oh well...
<br><br>-- bjm<br>_______________________________________________<br>mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br></blockquote></div><br>