Neat? It mihgt be very usefull, but it's rather a dirty hack in a
dirty language than a 'neat' solution.
\misiek
That is neat Gabor. Thanks, Ted
Gabor Grothendieck wrote:
The gsubfn package can do quasi perl-style interpolation by
prefacing any function call with fn$.
library(gsubfn)
Getting the basic stuff to work is trivially simple. I can connect, and, for
example, get everything in any given table.
What I have yet to find is how to deal with parameterized queries or how to
do a simple insert (but not of a value known at the time the script is
written - I ultimately want
Ted Byers wrote on 10/14/2008 02:33 PM:
Getting the basic stuff to work is trivially simple. I can connect, and, for
example, get everything in any given table.
What I have yet to find is how to deal with parameterized queries or how to
do a simple insert (but not of a value known at the time
Barry Rowlingson wrote on 10/14/2008 04:40 PM:
2008/10/14 Jeffrey Horner [EMAIL PROTECTED]:
I've found the best way to parameterize is using R's sprintf function. For
instance, the following query not only parameterizes the variable position,
but also the table name:
fields -
The gsubfn package can do quasi perl-style interpolation by
prefacing any function call with fn$.
library(gsubfn)
x - 3
fn$dbGetQuery(con, select * from myTable where myColumnA = $x and
MyColumnB = `2*x` )
See http://gsubfn.googlecode.com
On Tue, Oct 14, 2008 at 5:32 PM, Jeffrey Horner
[EMAIL
Thanks Jeffrey and Barry,
I like the humour. I didn't know about xkcd.com, but the humour on it is
familiar. I saw little Bobby Tables what seems like eons ago, when I first
started cgi programming.
Anyway, I recognized the risk of an injection attack with this use of
sprint, but in this
That is neat Gabor. Thanks, Ted
Gabor Grothendieck wrote:
The gsubfn package can do quasi perl-style interpolation by
prefacing any function call with fn$.
library(gsubfn)
x - 3
fn$dbGetQuery(con, select * from myTable where myColumnA = $x and
MyColumnB = `2*x` )
See
7 matches
Mail list logo