R help - May 2009 - create string of comma-separated content of vector

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.

see ?paste

e.g.

x <- seq(0,10,1)
paste(x, collapse=", ")


2009/5/19 Katharina May <may.katharina at
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 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.
>
>


-- 
Dr. Mark Wardle
Specialist registrar, Neurology
Cardiff, UK

See ?toString

x <- 0:10
toString(x)

See ?sQuote for cases where the vector is a character and needs to be quoted.

Jason Law
Statistician
City of Portland
Bureau of Environmental Services
Water Pollution Control Laboratory
6543 N Burlington Avenue
Portland, OR 97203-5452
jason.law at bes.ci.portland.or.us
> 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.
>