title: Compare input value from screen in SQLDF where clause
body: <p>I am new to <code>Shiny</code> and <code>R</code> both. I am trying to capture input value from <code>Shiny UI</code> part and based on the value, I am filtering the records from dataframe. I am using this code:</p>
  
  <pre><code>dat &lt;- sqldf("select * from dat where CMPNT_NM = 'input$Compound'")
  </code></pre>
  
  <p>It's not returning any rows, just column name is coming. If I give any hardcoded value like <code>mP</code>, then it's running perfectly. </p>
  
  <p>Any idea if I am doing something wrong? Thanks in advance.</p>