On 12/10/2007 11:49 AM, ONKELINX, Thierry wrote: > I think something like this would work. > > Change your query to > > rs <- dbSendQuery(con, statement = paste("select * from treatdata where > name='", whichDevice,"'", sep = "")) > > And then create a script like. > > whichDevice <- "Device1" > Sweave("myfile.rnw") > whichDevice <- "Device2" > Sweave("myfile.rnw")
Yes, I had forgotten that works. I usually use R CMD Sweave, where (as Gabor mentioned) it's harder to set variables. Duncan Murdoch ______________________________________________ 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.