Using alias in sqlQuery RStudio

Asked Jun 21 '17 at 18:19

Active Jun 21 '17 at 23:38

Viewed 533 times

I want to use a numerical alias in sqlQuery in R. For example, when I run:

x <- 2017

test <- sqlQuery(tdConnection, paste("SELECT * FROM Table where year=x;"))

I get an error:

Column x not found

Alias works for text, but not for integers. Is there a way to do it for integers?

edited Jun 21 '17 at 23:38

Scarabee

asked Jun 21 '17 at 18:19

alexsmith2

You should rather write it this way: `test<-sqlQuery(tdConnection, paste(" SELECT * FROM Table where year=", x))` – Scarabee Jun 21 '17 at 18:44
You can also have a look at this question: https://stackoverflow.com/questions/16178640/parameterized-queries-with-rodbc – Scarabee Jun 21 '17 at 18:46
thanks for the response. but what if there is a group by statement after the where statement? test<-sqlQuery(tdConnection, paste(" SELECT * FROM Table where year=x group by 1;")) – alexsmith2 Jun 21 '17 at 19:00
`paste("beginning of query ", x, " end of query")` – Scarabee Jun 21 '17 at 19:01
Thank you, Scarabee! That worked. – alexsmith2 Jun 21 '17 at 20:26

0 Answers0