<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
I think from memory that LIKE might be case sensitive. Please correct
me if I'm wrong.<br>
<br>
As a matter of course I tend to put UPPER around things to control this<br>
which would make your statements start to look like<br>
<br>
UPPER(program.title) LIKE '%DIRECTED BY%' OR .....<br>
<br>
You could always run both and see if you end up getting anymore hits.<br>
<br>
<br>
Dean<br>
<br>
<br>
<br>
Jason Taylor wrote:
<blockquote
cite="mid:94dd8f6f0811061444r33eb1849ke00b9ad48967b32c@mail.gmail.com"
type="cite">Anybody got some good custom record instructions?<br>
<br>
The current one I've got to record every movie on 1,2,3 or c4 is:<br>
<br>
(program.title LIKE '%directed by%' <br>
OR program.subtitle LIKE '%directed by%' <br>
OR program.description LIKE '%directed by%'<br>
OR program.title LIKE '%movie%' <br>
OR program.subtitle LIKE '%movie%' <br>
OR program.description LIKE '%movie%'<br>
OR program.title LIKE '%starring%' <br>
OR program.subtitle LIKE '%starring%' <br>
OR program.description LIKE '%starring%') <br>
AND TIMEDIFF(program.endtime, program.starttime) >
TIME('1:20:00.000000')<br>
<br>
Thats seems to more or less work.. anybody think of anything better?<br>
<br>
Jason<br>
<br clear="all">
<br>
-- <br>
"A little rudeness and disrespect can elevate a meaningless interaction
to a battle of wills and add drama to an otherwise dull day." - Calven<br>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
mythtvnz mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mythtvnz@lists.linuxnut.co.nz">mythtvnz@lists.linuxnut.co.nz</a>
<a class="moz-txt-link-freetext" href="http://lists.ourshack.com/mailman/listinfo/mythtvnz">http://lists.ourshack.com/mailman/listinfo/mythtvnz</a>
Archives <a class="moz-txt-link-freetext" href="http://www.gossamer-threads.com/lists/mythtv/mythtvnz/">http://www.gossamer-threads.com/lists/mythtv/mythtvnz/</a>
</pre>
</blockquote>
<br>
</body>
</html>