[mythtv] "-1 B" file sizes in MythWeb

[Chris Pinkham]

* On Fri Mar 02, 2007 at 10:15:32AM -0800, Yeechang Lee wrote:
> Chris Pinkham <cpinkham at bc2va.org> says:
> > I don't know, what is in the table for these, and is that still an
> > issue with current SVN trunk, or only with legacy 0.18-0.20.
 
> How do I see what's in the table? I don't know enough SQL syntax to
> know the answer without some coaching.

SELECT filesize FROM recorded WHERE chanid = X AND starttime = Y;

For X, put the chanid of the recording and for Y put the start time
in YYYYMMDDHHMMSS format (ie, 20070301034500 for March 1, 2007 at 3:45AM.

--
Chris