CDK Scheduler issue with Quotes

[ZaDDaZ]

I think CDK Scheduler is having a problem with single quotes in descriptions. This is really bad if you record any Stargate SG-1's as almost every episode description has the word "Goa'uld" in it... Here is the exception:

Code:

Unhandled Exception: System.Data.OleDb.OleDbException: Syntax error (missing operator) in query expression 'name='Stargate SG-1' and sub_title='Need' and description='Smitten Daniel learns Goa'uld secrets from an alien princess.''.
   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)
   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
   at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.OleDb.OleDbCommand.ExecuteReader()
   at RecTracker.RecordingTracker.hasShowBeenRecorded(String title, String subtitle, String description, String uniqueid)
   at RecordingUtils.RecordingUtils.isDuplicateRecorded(Recordings recording, Programme program)
   at RecordingUtils.RecordingUtils.passedRestrictions(Recordings recording, Programme program, ArrayList scheduleArray)
   at PriorityRecording.RecordingManager.pAddProgramList(RecordingUtils recordingUtil, IList programList, Recordings priorityRecordings, ArrayList scheduleArray)
   at PriorityRecording.RecordingManager.pAddPrograms(RecordingUtils recordingUtil, ArrayList scheduleArray)
   at PriorityRecording.RecordingManager.Main(String[] args)

[jrockintuitive]

I'll look into it. However, I do record SG-1. I do not think I get that error.

But I am away on business and when I get home, I might be unpleseantly surprised.

[jorm]

This should only occur if you are searching for a word that contains Goa'uld. Did you type it in or use xrecord?

the ' should be "

[ZaDDaZ]

Nope, I'm recording all shows by name now. I'll include my PriorityRecordings.xml file. Does this have something to do with not recording previously recorded episodes? Maybe it is doing a search for previously recorded episodes?

[KingArgyle]

ZaDDaZ:
What version of the RecTracker.dll do you have? I ran your PriorityRecordings.exe file on my system, with the RecTracker.dll date 2005-02-09 and didn't get the error.

The error is happening when checking to see if the show should be scheduled because of duplicate checking (i.e. you already recorded it).

[jorm]

Jrock,

Do you use the dll for rectracker or the class?

My class looks like it should handle the ' in the description. If you use the class can you check the RecTracker::hasShowBeenRecorded method. for the description replace.

string command = "select unqiue_id from RecordedShows where name='";
command += title.Replace("'", "''") + "' and sub_title='" + subtitle.Replace("'", "''") + "' and description='";
command += description.Replace("'", "''") + "'";

[KingArgyle]

Yep, that code is in the source I have for CDK Scheduler and the ReckTracker.cs code Jrock sent me. I know I'm using the RecTracker.DLL as I added that as a reference to RecordingUtils.dll, and didn't compile RecTracker into PriorityRecordings on the last bug fix for dates that I implemented.

[jrockintuitive]

King is correct... I use the compiled RecTracker.DLL

Just got back from an exhausting biz trip and ready to look at this issues... tomorrow morning

[ZaDDaZ]

The version of RecTracker I have is from 1/27/2005, which I downloaded on 4/7/2005. Is there a newer version on the WiKi now?

[jorm]

there is not, but I might create a debug version for you to try out.