is this what you want"

> x <- c(1, 2, 3, 4, 5)
> paste0("where ASSETT in (", paste(x, collapse = ','), ")")
[1] "where ASSETT in (1,2,3,4,5)"




On Fri, May 17, 2013 at 11:46 AM, Manta <mantino84@libero.it> wrote:

> Hi all,
>
> I have a vector of numbers, and to be able to pass it to RMySQL and use the
> IN clause I need to have this vector to be a single list numeric and comma
> separated.
>
> I saw the post below but it is about strings, which I do not need (I cannot
> pass strings in this SQL query, I need something like ' where ASSETT in
> (1,2,3,4,5)'
>
>
> http://stackoverflow.com/questions/6347356/creating-a-comma-separated-vector
>
>
> Any clue?
>
>
>
> --
> View this message in context:
> http://r.789695.n4.nabble.com/Comma-separated-vector-tp4667340.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> 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.
>



-- 
Jim Holtman
Data Munger Guru

What is the problem that you are trying to solve?
Tell me what you want to do, not how you want to do it.

	[[alternative HTML version deleted]]

