Re: [R] dbSendQuery with R variables

2010-05-12 Thread Gabor Grothendieck
Try this. If fn$ prefaces the function name, subject to certain rules string which determine which arguments are re-interpreted, interpolation somewhat like in perl occurs. Here we have enclosed stations[[1]] in back quotes. library(gsubfn) stations <- c("stationA", "stationB") rs_stations <- fn

Re: [R] dbSendQuery with R variables

2010-05-11 Thread kMan
pleQuery) Is this sort of what you had in mind? Sincerely, KeithC. -Original Message- From: Jonathan Greenberg [mailto:greenb...@ucdavis.edu] Sent: Monday, May 10, 2010 4:21 PM To: r-help Subject: [R] dbSendQuery with R variables Rhelpers: I'd like to modify this RSQLite state

Re: [R] dbSendQuery with R variables

2010-05-11 Thread Seth Falcon
On 5/11/10 5:01 AM, jim holtman wrote: ?paste On Mon, May 10, 2010 at 6:21 PM, Jonathan Greenberg wrote: Rhelpers: I'd like to modify this RSQLite statement: rs_stations<-dbSendQuery(con_stations, "select * from stations") so that stations is actually an R variable, e.g.: stations=c("stati

Re: [R] dbSendQuery with R variables

2010-05-11 Thread jim holtman
?paste On Mon, May 10, 2010 at 6:21 PM, Jonathan Greenberg wrote: > Rhelpers: > > I'd like to modify this RSQLite statement: > > rs_stations<-dbSendQuery(con_stations, "select * from stations") > > so that stations is actually an R variable, e.g.: > > stations=c("stationA","stationB") > > How wou

[R] dbSendQuery with R variables

2010-05-10 Thread Jonathan Greenberg
Rhelpers: I'd like to modify this RSQLite statement: rs_stations<-dbSendQuery(con_stations, "select * from stations") so that stations is actually an R variable, e.g.: stations=c("stationA","stationB") How would I modify the above statement to query from stations[[1]] (aka "stationA")? --j _