[R] RMySQL and free text variable

[H. Paul Benton]

Yea that worked !!
Did
paste(SELECT * FROM MET WHERE molid=", molid, "AND mode=", "\'" mode, 
"\'" , sep="")
I guess all I needed was the sep="" which I totally forgot about.

Cheers,

Paul

Eric wrote:
> Does this work for you?
>
> "SELECT * FROM data WHERE molNUM = 165 AND mode = '+'"
>
> Possibly related: when using the paste function, remember that you 
> might need explicitly set sep = "" and add your own padding where needed.
>
> Please re-post to the list if it works.
>
>
>
>