thanks, Jeff, good point... I'll try that
On Tue, Sep 17, 2013 at 9:43 AM, Jeff Newmiller <[email protected]>wrote: > 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. > > [[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.
