Have you tried putting double quotes around 2B and 3B: "...2B, 3B, ..." -> "...\"2B\",\"3B\",..."?
-Bill On Fri, Oct 2, 2020 at 3:49 PM Philip <herd_...@cox.net> wrote: > I’m trying to pull data from one table (batting) in the Lahman Baseball > database. Notice X2B for doubles and X3B for triples – fourth and fifth > from the right. > > The dbGetQuery function runs fine when I leave there two out but I get > error messages (in red) when I include 2B/3B or X2B/X3B. > > Can anyone give me some direction? > > Thanks, > Philip Heinrich > > *************************************************************************************************************************************************** > tail(dbReadTable(Lahman,"batting")) > > ID playerID yearID stint teamID team_ID > lgID G G_batting AB R H X2B X3B HR RBI SB > 107414 107414 yastrmi01 2019 1 SFN 2920 NL > 107 NA 371 64 101 22 3 21 55 2 > 107416 107416 yelicch01 2019 1 MIL 2911 NL > 130 NA 489 100 161 29 3 44 97 30 > 107419 107419 youngal01 2019 1 ARI 2896 NL > 17 NA 25 1 1 0 0 0 0 > 0 > 107420 107420 zagunma01 2019 1 CHN 2901 NL > 30 NA 36 2 9 3 0 0 5 > 0 > 107422 107422 zavalse01 2019 1 CHA 2900 AL > 5 NA 12 1 1 0 0 0 > 0 0 > 107427 107427 zimmery01 2019 1 WAS 2925 NL > 52 NA 171 20 44 9 0 6 27 0 > 107428 107428 zobribe01 2019 1 CHN 2901 NL > 47 NA 150 24 39 5 0 1 17 0 > 107429 107429 zuninmi01 2019 1 TBA 2922 AL > 90 NA 266 30 44 10 1 9 32 0 > > > Hack11Batting <- dbGetQuery(Lahman,"SELECT playerID,yearID,AB,R,H,2B,3B,HR, > RBI,SB,CS,BB,SO,IBB,HBP,SH,SF,GIDP FROM batting > WHERE yearID = 2018 AND AB >99") > Error: unrecognized token: "2B" > > Hack11Batting <- dbGetQuery(Lahman,"SELECT > playerID,yearID,AB,R,H,X2B,X3B,HR, > RBI,SB,CS,BB,SO,IBB,HBP,SH,SF,GIDP FROM batting > WHERE yearID = 2018 AND AB >99") > Error: no such column: X2B > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > 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. > [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.