title: How to pass input parameters to SQL query in Shiny
body: <p>When i select <strong>empno</strong> from the Input, that should pass to a select query.</p>
  
  <p>Using below, i am running <code>select * from emp</code> but how i can run the <code>select * from emp where empno = xxxx</code></p>
  
  <p>in server.R i want to run something like <code>select * from emp where empno = (user selected empno)</code></p>
  
  <p><strong>ui.R :</strong></p>
  
  <pre><code>shinyUI(bootstrapPage(
    title="Reactive-Bootstrap",responsive=TRUE,theme=NULL,
    titlePanel=h5("Employee Report - Reactive"),
  
    sidebarLayout(
      sidebarPanel(
        selectInput(inputId="select",label="Select Employee",
                    choices=c(7369,7499,7521,7566),selected=7369)),
  
      mainPanel(tableOutput("dis")))))
  </code></pre>
  
  <p><strong>server.R :</strong></p>
  
  <pre><code>library(RODBC)
  channel&lt;-odbcConnect("shiny",uid="scott",pwd="tiger")
  shinyServer(function(input,output){
    sql&lt;-sqlQuery(channel,"SELECT * FROM EMP")
    output$dis&lt;-renderTable(print(sql))
  })
  </code></pre>