0

In SQL, you are supposed to query a name such as "St. John's" as 'St. Johns'''s, where you replace the single quotes with two single quotes, or you can use double quotes and not do the double single quote. However, no matter what I try in R, it still tells me "unexpected string literal". Any help would be appreciated.code and error

Ted Henson
  • 1
  • 1
  • 2
    Please do not add screenshots of code. Add your actual code and error message to the question itself. Have a look at this for guidance on writing good questions: https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example – dww Feb 03 '19 at 16:31
  • You should be able to use query parameters instead of trying to modify the query text itself. Look up "parameters" in [bq-perform](https://github.com/r-dbi/bigrquery/blob/master/R/bq-perform.R). – Elliott Brossard Feb 03 '19 at 17:03
  • When I try that in a variety of ways, I get "Positional Parameters are not supported". I found another forum that says C does not support them, which is what R is written in, so I am not sure what to do now. – Ted Henson Feb 04 '19 at 15:14

1 Answers1

0

Remove the quote characters around your database, schema and table name.

unfinishedmonkey
  • 76
  • 5