[R] RMySQL query Help

Hello everyone, I am using RMySQL for a project and I have to deal with a complicated query here it is : tmp2 <-sprintf(paste("select Score from YR.Transcription_Factor inner join YR.Promoter on YR.Transcription_Factor. Promoter_idPromoter=YR.Promoter.idPromoter inner join YR.GP_BIS on YR.

Re: [R] rmysql query help

Hello, Okay, this is a help for me too, thanks! However, how do I do it for two variables/entries in the database? Thanks jorgusch Aaron Sims wrote: > > R HELP, > > I am trying to use an R script to connect to a mysql database. I am > having a problem using a variable in the where clause

Re: [R] rmysql query help

On 5/6/2009 3:47 PM, Aaron Sims wrote: R HELP, I am trying to use an R script to connect to a mysql database. I am having a problem using a variable in the where clause that contains a "space" in its value. If I include the variable inside the quotes of the query - i think it is searching fo

[R] rmysql query help

R HELP, I am trying to use an R script to connect to a mysql database. I am having a problem using a variable in the where clause that contains a "space" in its value. If I include the variable inside the quotes of the query - i think it is searching for the name of the variable in the databa