Displaying 1 result from an estimated 1 matches for "molnum".
Did you mean:
folnum
2007 Dec 13
1
RMySQL and free text variable
...of the 'mode' I get a table. How can I give the
'select' statement a variable and put it in free text ?
cheers,
Paul
library(RMySQL)
>con<- dbConnect(MySQL(), user, password, host, dbname)
> mode<-"+"
> query <- paste("SELECT * FROM data WHERE molNUM =", 165 , " AND mode
=", "\",mode,\"" ) ## my statement
> scans <- dbGetQuery(con, query)
> scans
NULL data frame with 0 row
> query <- paste("Select * FROM metabolite_msms WHERE molid =", 165 , "
AND mode =", "\"...