Try paste() i.e.
my_value = 10
library(RODBC)
inchannel <- odbcConnect("my_server",
uid="samay")
query <- paste("select item1, item2 from _my_table
where item3 >= 10
and dbid = ", my_value)
sqlQuery(inchannel,
query)
binding variable in sqlQuery
2 messages · ggorj@@@34155694 m@iii@g oii biogii@es@com, Sean Davis
On Tuesday 05 December 2006 05:36, ggorjan.34155694 at bloglines.com wrote:
Try paste() i.e.
my_value = 10
library(RODBC)
inchannel <- odbcConnect("my_server",
uid="samay")
query <- paste("select item1, item2 from _my_table
where item3 >= 10
and dbid = ", my_value)
sqlQuery(inchannel,
query)
I've been using sprintf more recently; I find it makes the queries much easier to read when there are multiple values that need to be inserted. Sean