R programming error RODBC

Question

I'm unable to understand how to pass a dataframe's column value to a query? 

I've stored the values in dframe$number:

dataframe <- sqlQuery(connection, "
+ SELECT
+ dimension1,
+ FROM
+ table1,
+ WHERE
+ dimension1 = dframe$number ")

I get the error:

 [1] "42S22 904 [Oracle][ODBC][Ora]ORA-00904: \"dframe$number\": invalid identifier\n"

Answer 1

You can perform quasi-perl-style string interpolation using the gsubfn package. 

library(gsubfn)

num <- 3
dataframe <- fn$sqlQuery(connection, 
         "SELECT dimension1 FROM table1 WHERE dimension1 = $num ")

Make use of paste or sprintf to construct the string:

sql <- paste("SELECT dimension1 FROM table1 WHERE dimension1 =", num)
sqlQuery(connection, sql)

or

sql <- sprintf("SELECT dimension1 FROM table1 WHERE dimension1 = %d", num)
sqlQuery(connection, sql)