Error: object 'ColumnName' not found

[subhashjaini]

I am querying from a linux server to a microsoft sql server database. I can retrieve the data without a problem, however, when I go to plot it, I get an error for every column I select saying object XXX not found.

Warning: Error in eval: object 'ColumnName' not found
Stack trace (innermost first):
87: eval [#1]
86: eval
85: plot_ly
84: eval
83: eval
82: %>%
81: "plotly"::"ggplotly" [/home/jainisuk/tmp/RtmpCbj1Nc/shinyapp65286caed272/dbplotR-master/app.R#502]
80: func
79: origRenderFunc
78: output$plot1
3: runApp
2: runUrl
1: runGitHub

Thanks!! :)

[dashee87]

Hi,

First of all, thanks for using the package.

I'm aware of this problem. It's related to the version of plotly that you have installed on your computer. After some update, plotly calls became plot_ly(x=~col1,y=col2,...). Without that '', you get errors such as the one you're seeing. I originally built the package as a tool to help me at work. I actually changed jobs and now don't use it anymore. But I will try to fix this. I just can't say when.

Sorry for the somewhat unhelpful answer.

David