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:<jdnew...@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 <mantin...@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. ______________________________________________ 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.