toSQLStringSet: Convert a vector to a quoted string for use as a SQL value...
In Bioconductor/AnnotationDbi: Manipulation of SQLite-based annotations in Bioconductor
toSQLStringSet R Documentation
Convert a vector to a quoted string for use as a SQL value list
Description
Given a vector, this function returns a string with each element of
the input coerced to character, quoted, and separated by ",".
Usage
toSQLStringSet(names)
Arguments
names
A vector of values to quote
Details
If names is a character vector with elements containing single
quotes, these quotes will be doubled so as to escape the quote in SQL.
Value
A character vector of length one that represents the input vector as a
SQL value list. Each element is single quoted and elements are
comma separated.
Note
Do not use sQuote for generating SQL as that function is
intended for display purposes only. In some locales, sQuote
will generate fancy quotes which will break your SQL.
Author(s)
Hervé Pagès
Examples
toSQLStringSet(letters[1:4])
toSQLStringSet(c("'foo'", "ab'cd", "bar"))
Bioconductor/AnnotationDbi documentation built on Nov. 2, 2024, 6:27 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
| toSQLStringSet | R Documentation |
Convert a vector to a quoted string for use as a SQL value list
Description
Given a vector, this function returns a string with each element of the input coerced to character, quoted, and separated by ",".
Usage
toSQLStringSet(names)
Arguments
names |
A vector of values to quote |
Details
If names is a character vector with elements containing single
quotes, these quotes will be doubled so as to escape the quote in SQL.
Value
A character vector of length one that represents the input vector as a SQL value list. Each element is single quoted and elements are comma separated.
Note
Do not use sQuote for generating SQL as that function is
intended for display purposes only. In some locales, sQuote
will generate fancy quotes which will break your SQL.
Author(s)
Hervé Pagès
Examples
toSQLStringSet(letters[1:4])
toSQLStringSet(c("'foo'", "ab'cd", "bar"))
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.