Re: [R] adding slashes in sql querys

2007-04-01 Thread Prof Brian Ripley
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

Re: [R] adding slashes in sql querys

2007-04-01 Thread Laurent Valdes
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

Re: [R] adding slashes in sql querys

2007-04-01 Thread Gabor Grothendieck
On 4/1/07, Laurent Valdes [EMAIL PROTECTED] wrote: 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

[R] adding slashes in sql querys

2007-03-31 Thread Laurent Valdes
Hi everybody, I'm doing a sqlSave() in R, to insert a big data frame of 1 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 -- We

Re: [R] adding slashes in sql querys

2007-03-31 Thread Gabor Grothendieck
Try this: 'my dog named Spot and my cat named Kitty fight like cats and dogs' On 3/31/07, Laurent Valdes [EMAIL PROTECTED] wrote: Hi everybody, I'm doing a sqlSave() in R, to insert a big data frame of 1 rows. However, there is problems, since several rows contains quotations marks,