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

[chao gai]

I am just confused by the eval parse \" and such.
what happens if simplify to :
g_1 <- sqlQuery(cnn_1, "select aa from bb.[cc\\dd].ee")
how would the query look in a native sql program?

Cheers,
Kees

On Tuesday 23 January 2007 17:29, Jakub Jurdziak wrote:
> Hello,
>
> 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.
>
> Kuba
>
> ______________________________________________
> R-help at 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.