On Mon, 28 Jul 2008, Megan J Bellamy wrote:
Hello all,
I am having trouble running a count function in R using RODBC to query a table
I created in Oracle. It may very well be that my SQL coding is incorrect; I
just started learning it. But if someone could point me in the right direction
or tell me if I am going about this the correct way that would be greatly
appreciated! The script I have right now is:
require(RODBC) channel<-odbcConnect("MeganXE") stbl<-sqlQuery(channel,
'select plotnum, sampyear, sptype from density') sqlQuery(channel,
'select count (sampyear, plotnum, sptype) from stbl where sampyear=1995
AND plotnum=1 AND sptype='S' OR sptype='H')
I get this error: unexpected symbol in "sqlQuery(channel...)"
I would like R to return a count of how many records satisfy the
condition of being sampled in 1995 and in plot number 1, where the
species type is either softwood or hardwood (S or H). Any help with this
would be great.
Well that error message I am almost certain is saying your SQL code is
wrong and it is pretty easy to see that the quote marks will cause you
problems.
Try using double quotes in the SQL code ("S", "H") and don't forget to
close the single quote which starts at 'select. (That is you need a ' just
before the closing bracket.
David scott
_________________________________________________________________
David Scott Department of Statistics, Tamaki Campus
The University of Auckland, PB 92019
Auckland 1142, NEW ZEALAND
Phone: +64 9 373 7599 ext 86830 Fax: +64 9 373 7000
Email: [EMAIL PROTECTED]
Graduate Officer, Department of Statistics
Director of Consulting, Department of Statistics
______________________________________________
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.
