[R] Unrecognized token

[Jeff Newmiller]

Why don't you print the 'query' variable with each id value and consider what the SQL syntax is for number and string literals. Then study the use of escaping in strings ("\\") to fix the query.
---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
--------------------------------------------------------------------------- 
Sent from my phone. Please excuse my brevity.

srecko joksimovic <sreckojoksimovic at gmail.com> wrote:
>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]]
>
>______________________________________________
>R-help at 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.