Re: [R] adding slashes in sql querys

From: Laurent Valdes <valderama_at_gmail.com>
Date: Sun 01 Apr 2007 - 18:25:05 GMT

Hi everybody,

really sorry !!!
this is RODBC indeed. But I'm not sure if the package or R version makes a real difference.
In fact, I used fast=FALSE, and I'm now pretty sure the error is due to that parameter.
It may be working far better with fast=TRUE. Gabor, I do not understand how the heck can cats and dogs have interaction with backslashes in SQL queries.

However many thanks !!!

Regards,
Laurent.

2007/4/1, Prof Brian Ripley <ripley@stats.ox.ac.uk>:
>
> I think this is about RODBC, uncredited.
>
> There is currently no way to do escapes here, and I am pretty sure that
> ODBC drivers do not support 'slash' as an escape (or did you mean
> backslash? I am still not sure that would work).
>
> sqlSave() has fast=TRUE and fast=FALSE options, and it is worth trying
> both. Since the default fast=TRUE passes character data as binary fields,
> I don't understand why there is a problem (there might be for fast=FALSE
> with single quotes in character fields).
>
> Without any relevant details (OS, R version, packages used, package
> version, ODBC driver, DBMS) and any sort of example it is really hard to
> offer help: please DO study the R posting guide (and note also the comment
> about using a signature block).
>
> On Sat, 31 Mar 2007, Laurent Valdes wrote:
>
> > Hi everybody,
> >
> > I'm doing a sqlSave() in R, to insert a big data frame of 10000 rows.
> > However, there is problems, since several rows contains quotations
> marks,
> > that can leave inserts buggy.
> > I would like to find a way to add slashes in front of these quotation
> marks.
> >
> > Best regards,
> >
> > Laurent
> >
> >
> >
>
> --
> Brian D. Ripley, ripley@stats.ox.ac.uk
> Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/
> University of Oxford, Tel: +44 1865 272861 (self)
> 1 South Parks Road, +44 1865 272866 (PA)
> Oxford OX1 3TG, UK Fax: +44 1865 272595
>

-- 
We are drowning in information, but starved for knowledge.
«Germain» @<http://www.le-valdo.com>

	[[alternative HTML version deleted]]


______________________________________________ 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 Mon Apr 02 04:32:33 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 Sun 01 Apr 2007 - 19:30:36 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.