title: Inserting Ruby String into Sqlite
body: <p>I have an example string "Canon PowerShot 12.1-Megapixel" and when I run the following code, it seems to fail:</p>
  
  <pre><code>db.execute "CREATE TABLE IF NOT EXISTS Products( id INTEGER PRIMARY KEY, stockID INTEGER, Name TEXT )" 
  
  id = 12345
  name = "Canon PowerShot 12.1-Megapixel"       
  
  db.execute( "INSERT INTO Products ( stockID, Name ) VALUES ( #{id}, #{name} )" )
  </code></pre>
  
  <p>The error code is:</p>
  
  <pre><code>C:/Ruby/Ruby193/lib/ruby/gems/1.9.1/gems/sqlite3-1.3.6-x86-mingw32/lib/sqlite3/d
  atabase.rb:91:in `initialize': near "PowerShot": syntax error
  (SQLite3::SQLExcep tion)
          from C:/Ruby/Ruby193/lib/ruby/gems/1.9.1/gems/sqlite3-1.3.6-x86-mingw32/
  lib/sqlite3/database.rb:91:in `new'
          from C:/Ruby/Ruby193/lib/ruby/gems/1.9.1/gems/sqlite3-1.3.6-x86-mingw32/
  lib/sqlite3/database.rb:91:in `prepare'
          from C:/Ruby/Ruby193/lib/ruby/gems/1.9.1/gems/sqlite3-1.3.6-x86-mingw32/
  lib/sqlite3/database.rb:134:in `execute'
          from E:/Documents/Cowboom/scraping/DBDOTDList.rb:48:in `&lt;main&gt;'
  </code></pre>
  
  <p>Any idea why this dies after "PowerShot"?</p>