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 -

Re: [R] dbSendQuery with R variables

2010-05-11 Thread jim holtman
?paste On Mon, May 10, 2010 at 6:21 PM, Jonathan Greenberg greenb...@ucdavis.eduwrote: 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

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 greenb...@ucdavis.eduwrote: 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.:

Re: [R] dbSendQuery with R variables

2010-05-11 Thread kMan
) 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 statement: rs_stations

[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