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 <wdunlap@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-bounces@r-project.org [mailto:r-help-bounces@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]]

