Re: [R] SQL select ... where R variable

2011-12-14 Thread agent dunham
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

Re: [R] SQL select ... where R variable

2011-12-14 Thread Gabor Grothendieck
On Wed, Dec 14, 2011 at 7:04 AM, agent dunham crossp...@hotmail.com wrote: 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

[R] SQL select ... where R variable

2011-12-13 Thread agent dunham
Before loading sql packages, i was wondering, once all packages required are installed, if it's possible to do from R console sth like this: SQL select v1 from sql_table where v2 in (R_variable) # being R_variable a vector Thanks in advance, u...@host.com -- View this message in

Re: [R] SQL select ... where R variable

2011-12-13 Thread Gabor Grothendieck
On Tue, Dec 13, 2011 at 10:54 AM, agent dunham crossp...@hotmail.com wrote: Before loading sql packages, i was wondering, once all packages required are installed, if  it's possible to do from R console sth like this: SQL select v1 from sql_table        where v2 in (R_variable)  # being