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.
You are wrong... since the SQL query you wish to create is itself a string.
Of course, you cannot send a SQL fragment such as you used as an example, so be
sure to form a complete, syntactically correct SQL statement before giving it to
your database query function.
Oh, and if you need more assistance with this topic, then you should probably
post in the R-sig-DB mailing list. Please also keep in mind that the actual SQL
syntax used for your specific database is basically off-topic in any R forum, so
you may need other help resources as well.
---------------------------------------------------------------------------
Jeff Newmiller The ..... ..... Go Live...
DCN:<jdnewmil at dcn.davis.ca.us> Basics: ##.#. ##.#. Live
Go...
Live: OO#.. Dead: OO#.. Playing
Research Engineer (Solar/Batteries O.O#. #.O#. with
/Software/Embedded Controllers) .OO#. .OO#. rocks...1k
---------------------------------------------------------------------------
Sent from my phone. Please excuse my brevity.
Manta <mantino84 at 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 at 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.
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]]