title: SQLite3 database insert using variables
body: <p>I am writing a script that exports results into a SQLite database. I can not get the code to work when I use variables.</p>
  
  <p>Here is an excerpt:</p>
  
  <pre><code>require 'sqlite3'
  require 'shodan'
  
  table_name = "#{Date.today.strftime("%B")}#{Time.now.year}_Findings"
  db = SQLite3::Database.new "shodan_test.db"
  db.execute ("CREATE TABLE #{table_name} (ip string , ports string)")
  
  results = api.host(target)
  
  ip = results["ip_str"].to_s
  ports = results["ports"].to_s
  
  db.execute ("insert into #{table_name} (ip, ports) values (#{ip}, #{ports})")
  </code></pre>
  
  <p>The code fails at the last line.  I can remove the variables and the code works. I'm a bit confused since the CREATE TABLE works with a variable. </p>