title: Calling sql from R
body: <pre><code>con &lt;- dbConnect(odbc::odbc(), 
                   Driver = "xxx", 
                   Server = "xxxx", 
                   Database = "xx", uid = "xxx", pwd = "xxx")
  </code></pre>
  
  <p>ABove is the function to call sql queries
   and below is the code to call the table in R</p>
  
  <pre><code>fac &lt;- dbGetQuery(con, "(select * from table where Category = '",input$Cat,"')") ##input$Cat is called in UI.R
  </code></pre>
  
  <p>But the above statement is not getting executed. Am i calling <code>'",input$Cat,"'</code> wrongly ? </p>