Hello guys,
I need your help regarding an error in R.
I'm using GLUE package to make a search on my DB (Oracle), and it works very well when I put the value directly into the code, like above:
...
where
pla.cod_pedido = '0000545461' <--------------
and pla.cod_item = '000010' <-------------
and pla.cod_ordem_producao = ro.cod_ordem_producao
BUT, when i change this value to a numeric INPUT, like:
...
where
pla.cod_pedido = {as.numeric(input$pedido)} <--------------
and pla.cod_item = {as.numeric(input$item)} <-------------
and pla.cod_ordem_producao = ro.cod_ordem_producao
It does not work. I'm using the same values for both of the input's.
I think i can be a syntax error, but i don't have sure.
UI
numericInput("pedido")
numericInput("item")