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
______________________________________________
[email protected] 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, [EMAIL PROTECTED]
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
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
