[mythtv-users] Set up a Holiday Special Recording Schedule??

[jarpublic at gmail.com]

On Wed, Dec 3, 2008 at 2:22 PM, Brad DerManouelian
<myth at dermanouelian.com> wrote:
> On Dec 3, 2008, at 11:08 AM, boehm100 at comcast.net wrote:
>
>>> You could do it based on chanid. For instance, all my OTA chanid's
>>> start with 1 so if I only wanted to catch the programs only when they
>>> are available OTA (all my digital channels), I would add:
>>>
>>> AND chanid BETWEEN 999 AND 2000
>>>
>>> I don't know enough about the scheduler to suggest a way to limit it
>>> to a single tuner.
>>>
>>> -Brad
>>>
>>
>> What about:
>> AND chanid *.1
>
> I just tried that and it didn't limit my chanid at all so I'm not sure
> what the purpose is.
>
> mysql> select count(*) from program WHERE program.category like
> '%holiday%' and chanid * .1;
> +----------+
> | count(*) |
> +----------+
> |     1080 |
> +----------+
> 1 row in set (0.21 sec)
>
> mysql> select count(*) from program WHERE program.category like
> '%holiday%';
> +----------+
> | count(*) |
> +----------+
> |     1080 |
> +----------+
> 1 row in set (0.21 sec)
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>

I don't really know much about sql, but it looks to me like you have
an extra space in there. Try *.1 instead of * .1.