Re: [R] sqlQuery and string selection

From: paul sorenson <paul_at_metrak.com>
Date: Thu 20 Oct 2005 - 08:04:41 EST

Jérôme Lemaître wrote:
> Dear alls,
>
> Could someone tell me how to select a subset of string observations (e.g.
> "females" in a sex column) with sqlQuery in the RODBC library?
>
> Indeed, I'm trying to select a subset of observations on my access database
> with:
>
> female<-sqlQuery(mychannel,"SELECT Micromammiferes.sex
> FROM Micromammiferes
> WHERE (((Micromammiferes.sex)="females"));")
>
> The sql works well in access but in R, I keep getting:
>
> Error: syntax error.

R is likely to have problems with nested quote characters.

Ie:

x = "SELECT Micromammiferes.sex FROM Micromammiferes WHERE (((Micromammiferes.sex)="females"));"

also results in a syntax error (my mailer split the line).



R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Thu Oct 20 08:11:44 2005

This archive was generated by hypermail 2.1.8 : Sun 23 Oct 2005 - 19:07:23 EST