see ?paste e.g.
x <- seq(0,10,1) paste(x, collapse=", ") 2009/5/19 Katharina May <may.kathar...@googlemail.com>: > Hi, > > how do I create a string of the comma-separated content of a vector? > > I've got the vector i with several numeric values as content: >>str(i) > num 99 > > and want to create a SQL statement to look like the following where > the part '(2, 4, 6, 7)' should be > the content of the vector i: > select * from [biomass_data$] where site_no in (2, 4, 6, 7) > > Here my approach (which doesn't work): > site_all_data <= sqlQuery(channel, "select * from [biomass_data$] > where site_no in (",paste(i,sep=","),") ) > > > sorry for spaming so much today to the mailing list... > > -Katharina > > -- > Time flies like an arrow, fruit flies like bananas. > > ______________________________________________ > 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. > > -- Dr. Mark Wardle Specialist registrar, Neurology Cardiff, UK ______________________________________________ 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.