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:<[email protected]> 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 <[email protected]> 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]]
>
>______________________________________________
>[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.
______________________________________________
[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.
