title: Sqlite error in Objective C
body: <p>I am trying to delete some entries in my sqlite database on my iPhone app, but am getting a weird error. </p>
  
  <p>Here is my code:</p>
  
  <pre><code>if(sqlite3_open([databasePath UTF8String], &amp;yerocDB)==SQLITE_OK)
  {   
      sqlite3_stmt *compiledstatement;
  
      NSString *deleteSql=[NSString stringWithFormat: @"delete from Favorites_Table where playlist_name = Studying and date = 1/1/2012"];
      const char *sqlstmt = [deleteSql UTF8String];
  
      if(sqlite3_prepare_v2(yerocDB, sqlstmt, -1, &amp;compiledstatement, NULL)==SQLITE_OK)
      {
          int result = sqlite3_step(compiledstatement);
  
          if(SQLITE_DONE != result)
  
              NSAssert1(0,@"Error while creating delete statement =&gt; %s",sqlite3_errmsg(yerocDB) );
      }else{
          NSLog(@"didn't delete error: %s", sqlite3_errmsg(yerocDB));
      }
      sqlite3_finalize(compiledstatement);
  }
  </code></pre>
  
  <p>but then I get the error:</p>
  
  <pre><code>didn't delete error: no such column: Studying
  </code></pre>
  
  <p>playlist_name and date are my columns...Why is it saying the "Studying" is not a column?</p>