SQLLITE

[nexes]

Hello All,
   I am having a minor problem when I try and do this:
      c.execute("insert into [tblTranscripts] (MovieID,Transcript)
Values(" + movieID + ",'" + formatText + "');")   (don't even bother
commenting of the sql style I know its bad form but this is a simple
script). Whenever I try and do the insert I get table not found,
however when I perform the sql through sqlite's command line program
(the sql is outputted via a print statement) it works fine.  Any ideas?