<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
I'm trying to setup a schedule for actor = 'Will Smith' and category =
'film' (I've seen most of the fresh prince. I found a page on the wiki
- <a class="moz-txt-link-freetext" href="http://www.mythtv.org/wiki/Custom_Recording">http://www.mythtv.org/wiki/Custom_Recording</a> that suggests;<br>
<br>
<ul>
<li> Additional tables = "JOIN credits AS c ON
c.chanid=program.chanid AND c.starttime=program.starttime JOIN people
AS p ON p.person=c.person"
</li>
<li> Search phrase = "p.name = 'Will Smith' AND program.category_type
= 'Film'"
</li>
</ul>
However, when i try this (from mythweb) I get a SQL error around the
additional tables part. My system is running on Mythbuntu Karmic
(9.10) and Myth 0.22. I can succesfully run it as pure SQL;<br>
<br>
<code class="sql"><span class="syntax"><span
class="syntax_alpha syntax_alpha_reservedWord">SELECT</span> <span
class="syntax_punct">*</span> <br>
<span class="syntax_alpha syntax_alpha_reservedWord">FROM</span> <span
class="syntax_alpha syntax_alpha_identifier">program</span><br>
<span class="syntax_alpha syntax_alpha_reservedWord">JOIN</span> <span
class="syntax_alpha syntax_alpha_identifier">credits</span> <span
class="syntax_alpha syntax_alpha_reservedWord">AS</span> <span
class="syntax_alpha syntax_alpha_identifier">c</span> <span
class="syntax_alpha syntax_alpha_reservedWord">ON</span> <span
class="syntax_alpha syntax_alpha_identifier">c</span><span
class="syntax_punct syntax_punct_qualifier">.</span><span
class="syntax_alpha syntax_alpha_identifier">chanid</span> <span
class="syntax_punct">=</span> <span
class="syntax_alpha syntax_alpha_identifier">program</span><span
class="syntax_punct syntax_punct_qualifier">.</span><span
class="syntax_alpha syntax_alpha_identifier">chanid</span><br>
<span class="syntax_alpha syntax_alpha_reservedWord">AND</span> <span
class="syntax_alpha syntax_alpha_identifier">c</span><span
class="syntax_punct syntax_punct_qualifier">.</span><span
class="syntax_alpha syntax_alpha_identifier">starttime</span> <span
class="syntax_punct">=</span> <span
class="syntax_alpha syntax_alpha_identifier">program</span><span
class="syntax_punct syntax_punct_qualifier">.</span><span
class="syntax_alpha syntax_alpha_identifier">starttime</span><br>
<span class="syntax_alpha syntax_alpha_reservedWord">JOIN</span> <span
class="syntax_alpha syntax_alpha_identifier">people</span> <span
class="syntax_alpha syntax_alpha_reservedWord">AS</span> <span
class="syntax_alpha syntax_alpha_identifier">p</span> <span
class="syntax_alpha syntax_alpha_reservedWord">ON</span> <span
class="syntax_alpha syntax_alpha_identifier">p</span><span
class="syntax_punct syntax_punct_qualifier">.</span><span
class="syntax_alpha syntax_alpha_identifier">person</span> <span
class="syntax_punct">=</span> <span
class="syntax_alpha syntax_alpha_identifier">c</span><span
class="syntax_punct syntax_punct_qualifier">.</span><span
class="syntax_alpha syntax_alpha_identifier">person</span><br>
<span class="syntax_alpha syntax_alpha_reservedWord">WHERE</span> <span
class="syntax_alpha syntax_alpha_identifier">p</span><span
class="syntax_punct syntax_punct_qualifier">.</span><span
class="syntax_alpha syntax_alpha_identifier">name</span> <span
class="syntax_punct">=</span> <span
class="syntax_quote syntax_quote_single">'Will Smith'</span><br>
<span class="syntax_alpha syntax_alpha_reservedWord">AND</span> <span
class="syntax_alpha syntax_alpha_identifier">program</span><span
class="syntax_punct syntax_punct_qualifier">.</span><span
class="syntax_alpha syntax_alpha_identifier">category_type</span> <span
class="syntax_punct">=</span> <span
class="syntax_quote syntax_quote_single">'movie'<br>
<br>
</span></span></code>and this works fine ? Anyone have any other ideas
?<br>
</body>
</html>