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
?paste
See also,
http://rwiki.sciviews.org/doku.php?id=large_scale_data:lsdioi_sqchunk for
additional examples.
Assuming stations[1:2] are tables your database:
simpleQuery<- paste("SELECT * FROM", stations[1]) # should read the whole
table when invoked
dbGetQuery(con_stations, simpleQuery)
Is t
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
?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
4 matches
Mail list logo
