[R] adding slashes in sql querys

Gabor Grothendieck ggrothendieck at gmail.com
Sat Mar 31 19:17:06 CEST 2007


Try this:

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

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



More information about the R-help mailing list