[Rd] typo in example(dbEscapeStrings) (PR#13521)

mayeul.kauffmann at ecoledelapaix.org mayeul.kauffmann at ecoledelapaix.org
Thu Feb 12 17:00:07 CET 2009

Full_Name: Mayeul Kauffmann
Version: 2.8.1
OS: x86_64-pc-linux-gnu (kubuntu)
Submission from: (NULL) (

The file /library/RMySQL/html/dbEscapeStrings.html documents dbEscapeStrings()
In the example, an 's' is missing in line 3:

## Not run: 
tmp <- sprintf("select * from emp where lname = %s", "O'Reilly")
sql <- dbEscapeString(con, tmp)
dbGetQuery(con, sql)
## End(Not run)

sql <- dbEscapeString(con, tmp)
should be:
sql <- dbEscapeStrings(con, tmp)

More information about the R-devel mailing list