Re: [R] adding slashes in sql querys

From: Gabor Grothendieck <ggrothendieck_at_gmail.com>
Date: Sat 31 Mar 2007 - 17:17:06 GMT

Try this:

'my dog named "Spot" and my cat named "Kitty" fight like cats and dogs'

On 3/31/07, Laurent Valdes <valderama@gmail.com> 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
>
>
> --
> 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.
>
>



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 Sun Apr 01 03:22:27 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 Sat 31 Mar 2007 - 18:30:38 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.