Manual Recording Advance Rules

[jcjefferies]

I have used the Advance Rules under Manual Recordings to catch variations of a programme title such as:-
title like 'Red Dwarf%'

This catches anything starting with the specified words. However some time ago I setup a rule:-
title like '%PD James%'
Should this record anything with those words somewhere in the title. Its not made a recording yet but I dont know if there has been anything to record.

I am now trying to record variations of a programme called "You've Been Framed" where the title can be preceeded by one of several words. The problem is the ' in "You've" causes a SQlite error near "ve". Is there a character I can put in front of ' to tell SQlite to ignore it?

[sub]

This catches anything starting with the specified words. However some time ago I setup a rule:-
title like '%PD James%'
Should this record anything with those words somewhere in the title. Its not made a recording yet but I dont know if there has been anything to record.

Yes, that should record any shows with "PD James" somewhere in the title. If you zip and attach your npvr.db3, I can take a look.

I am now trying to record variations of a programme called "You've Been Framed" where the title can be preceeded by one of several words. The problem is the ' in "You've" causes a SQlite error near "ve". Is there a character I can put in front of ' to tell SQlite to ignore it?

You could do '%ve Been Framed%". I'm pretty sure SQLite also allows you to escape a single quote by placing two quotes in a row:

title like '%You''ve Been Framed%'

[jcjefferies]

Thanks Sub, I can confirm that both your suggested work arounds for the ' in the title work. I should have seen your first option myself but I decided to use the escape character version.

I have no reason to think that my "PD James" rule wont work, it is just that all my other rules have the trailing % so was just looking for confirmation that it should work. Thanks again.