[R] Comma separated vector

Jeff Newmiller jdnewmil at dcn.davis.CA.us
Fri May 17 18:29:12 CEST 2013

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
>IN clause I need to have this vector to be a single list numeric and
>I saw the post below but it is about strings, which I do not need (I
>pass strings in this SQL query, I need something like ' where ASSETT in
>Any clue?
>View this message in context:
>Sent from the R help mailing list archive at Nabble.com.
>R-help at r-project.org mailing list
>PLEASE do read the posting guide
>and provide commented, minimal, self-contained, reproducible code.

More information about the R-help mailing list