[mythtv-users] SQL error in "instant recording"

[Brent Michalski]

My instant recording is still not working and I have tracked the problem
to an error in the SQL before the recording begins.

Here is the SQL:

SELECT recordid 
FROM   record 
WHERE 
 record.title = "sdsd " AND 
 ((record.type = 4) OR ((record.chanid =  ) AND   <-- ERROR HERE
 ((record.type = 3) OR 
  (((TIME_TO_SEC(record.starttime) = TIME_TO_SEC('09:28:23'))  AND 
    (TIME_TO_SEC(record.endtime)   = TIME_TO_SEC('09:29:23'))) AND
  ((record.type = 2) OR
  ((DAYOFWEEK(record.startdate) = DAYOFWEEK('2003-08-16') AND
  ((record.type = 5) OR
  ((TO_DAYS(record.startdate) = TO_DAYS('2003-08-16')) AND
   (TO_DAYS(record.enddate) = TO_DAYS('2003-08-16')))))))))));


How can I get the chanid, or if it is not needed, can we just quote
these values to prevent this?

I am going to dig around the source a bit and see if I can find where
this is happening, but I wanted to get this out and see if it is a known
problem and how I can fix it.

Thanks!

Brent
--
Have you bought your SCO license?  I have!
http://www.perlguy.net/sco.html