[R] sqlQuery and string selection
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
Re: [R] sqlQuery and string selection
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
Re: [R] sqlQuery and string selection
(sorry if a duplicate pops through ...) 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. Most computer software has 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
Re: [R] sqlQuery and string selection
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, [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, UKFax: +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