Thanks William, actually, the combination that works is: with(list(id=c("1234","abcd")), paste(paste("select * from tbl_user where student_id = '78789D'", sep=""), " order by date_time", sep=""), maybe I should try to replace double quotes with single (opposite of what I was doing...)
On Tue, Sep 17, 2013 at 9:16 AM, William Dunlap <wdun...@tibco.com> wrote: > Look at the query strings your code produces: > > > with(list(id=c("1234","abcd")), paste(paste("select * from tbl_user > where student_id = ", id, > sep=""), " order by date_time", sep="") > ) > [1] "select * from tbl_user where student_id = 1234 order by date_time" > [2] "select * from tbl_user where student_id = abcd order by date_time" > > I suspect that the abcd should have quotes around it. If student_id is > stored > as string data the 1234 should probably also have quotes around it. > Replace > id > with > "\"", id, "\"" > and you may get a query that works. > > Bill Dunlap > Spotfire, TIBCO Software > wdunlap tibco.com > > > > -----Original Message----- > > From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] > On Behalf > > Of srecko joksimovic > > Sent: Tuesday, September 17, 2013 9:04 AM > > To: R help > > Subject: [R] Unrecognized token > > > > 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@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. > [[alternative HTML version deleted]] ______________________________________________ R-help@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.