title: How to insert Perl variables into Sqlite3
body: <p>I want to insert values into Sqlite3 table using Perl DBI. I was able to insert hard coded values without any problem. When I tried to use perl variables, then I get an error "DBD::SQLite::db do failed: no such column:"</p>
  
  <p>This works:</p>
  
  <pre><code>$dbh-&gt;do("insert into Gene values (12, 'AAAAAA', 66, 86, 76)");
  </code></pre>
  
  <p>But this code</p>
  
  <pre><code>$dbh-&gt;do("INSERT INTO Gene values (NULL, $sequence, $siteNumber, $begin, $length)");
  </code></pre>
  
  <p>throws the error</p>
  
  <pre><code>DBD::SQLite::db do failed: no such column
  </code></pre>