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 <[EMAIL PROTECTED]> 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@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@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@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.
