Displaying 1 result from an estimated 1 matches for "molid".
Did you mean:
solid
2007 Dec 13
1
RMySQL and free text variable
...> 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 =", "\"+\"" )##only difference is that mode is replace by +
> scans <- dbGetQuery(con, query)
> scans
molNUM mz intensity fwhm mode adduct
1 165 385.5790 0.492911 0.0975147 +
2 165 111.1130 0.497857...