Re: [R] sqlQuery and string selection

From: Prof Brian Ripley <ripley_at_stats.ox.ac.uk>
Date: Thu 20 Oct 2005 - 08:22:34 EST

The syntax error is that you have unescaped quotes inside quotes. You also do not need a semicolon, nor to refer to columns in this table.column form. Try

'select sex from Micromammiferes where sex="females"'

(I suspect you do not need quotes, but keep forgetting the quirks of various DBMSs.)

On Wed, 19 Oct 2005, 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.
>
> Any help would be very appreciated,
>
> Thanks a lot
>
> Jérôme Lemaître
> Ph.D. student
> Départment of biology,
> University Laval
> Quebec, Canada
>
> ______________________________________________
> 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
>

-- 
Brian D. Ripley,                  ripley@stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

______________________________________________ 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:27:03 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:40:46 EST