[R] SQL> select ... where "R variable"

agent dunham crosspide at hotmail.com
Wed Dec 14 13:04:31 CET 2011


Thank you, 

I guess it didn't work for me, maybe is not possible?

I've tried: 

> con<- odbcDriverConnect("Driver=SQL Server;
> Server=...\\...;Database=...;Uid=...;Pwd=... ;")

> v1=sqlQuery(con, "select v1 from sqltable where v3 =cte and v2 in (select
> v2 from R_dataframe) order by (select v2 from R_dataframe)")

> head(rbind(R_dataframe$v2, v1))
       [,1]                                                                                               
       "1251"                                                                                             
v1 "42S02 208 [Microsoft][ODBC SQL Server Driver][SQL Server]*The name of
the object 'R_dataframe' is not valid.*"

Thanks in advance, 
user at host.com
   

--
View this message in context: http://r.789695.n4.nabble.com/SQL-select-where-R-variable-tp4190882p4194629.html
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list