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

[Gabor Grothendieck]

If the question is how to represent a character string containing double
quotes without using \" then just use single quotes for the entire string
instead:

'He said "dog" and she said "cat".'

On 1/23/07, chao gai <chaogai at duineveld.demon.nl> wrote:
> 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.
>
> ______________________________________________
> 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.
>