[R] [R-pkgs] eval() parse() and problem with square brackets

From: Jakub Jurdziak <enzo83_at_wp.pl>
Date: Mon 22 Jan 2007 - 22:16:18 GMT


i have problem with the following code (I'm using sqlQuery function from RODBC package):
eval(parse(text="g_1 <- sqlQuery(cnn_1, \"select aa from bb.[cc\\dd].ee\")")).

I get the error message:
"[RODBC] ERROR: Could not SQLExecDirect"

"S0002 208 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object
name 'bb.cc\dd.ee'."

It seems that R is replacing square brackets that are needed for database to execute query.

How can I force R to change its behavior and leave square brackets unchanged?

Any ideas appreciated


R-packages mailing list

R-help@stat.math.ethz.ch 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. Received on Tue Jan 23 22:43:58 2007

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Tue 23 Jan 2007 - 12:30:28 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.