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.
>
>
>
>

______________________________________________
R-help@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.

Reply via email to