Hi,<div><br></div><div>I want to be able to do a power search and record all movies when one or more actors are on the role list. I have followed the guide on the wiki: <a href="http://www.mythtv.org/wiki/Custom_Recording">http://www.mythtv.org/wiki/Custom_Recording</a>: People Search replacement: An Advanced Custom Recording Example</div>
<div><br></div><div>In mythweb->Custom->Power Search->Additional tables, I put the string:</div><div> "JOIN credits AS c ON c.chanid=program.chanid AND c.starttime=program.starttime JOIN people AS p ON p.person=c.person"</div>
<div><br></div><div>And in the search part:</div><div><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:13px;line-height:19px">"<a href="http://p.name">p.name</a> = 'Bruce Willis'</span><br></div>
<div><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:13px;line-height:19px"><br></span></div><div><font color="#000000" face="sans-serif"><span style="line-height:19px">When I submit this, an error is thrown, caused by an invalid "," that is put before the Join statement. This has to be an error in the mythweb script. So I tried to do the same from the frontend. Here it is possible to put in the join statement, but it still doesn't find any recordings.</span></font></div>
<div><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:13px;line-height:19px"><br></span></div><div><span style="color:rgb(0,0,0);font-family:sans-serif;font-size:13px;line-height:19px">Does anyone have a working rule to spare?</span></div>