Hi,
when I generate query using sqldf library, like this:
query = paste(paste("select * from tbl_user where student_id = ", id,
sep=""), " order by date_time", sep="")
student <- sqldf(query)
everything works fine in case the id is "21328", "82882", or something like
that. But, when id is something like "78789D", there is an error:
Error in sqliteExecStatement(con, statement, bind.data) :
RS-DBI driver: (error in statement: unrecognized token: "78789D")
I tried replacing single quotes with double, but it still doesn't work...
thanks,
Srecko
[[alternative HTML version deleted]]
______________________________________________
[email protected] 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.
