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 <[EMAIL PROTECTED]>: > > 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, [EMAIL PROTECTED] > 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]]
______________________________________________ [email protected] 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.
