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$dbSendQuery(con_stations, "select * from `stations[[1]]`") On Mon, May 10, 2010 at 6:21 PM, Jonathan Greenberg <greenb...@ucdavis.edu> 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 would I modify the above statement to query from stations[[1]] > (aka "stationA")? > > --j > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.