[R] using sprintf to pass a variable to a RMySQL query

[alison waller]

Thanks Gabor,

As I said I would like to use gsubfn, but I am having problems
installing it, which I assume are due to some conflict with the current
tcltk package

Below is the error I got after issuing install.packages("gsubfn")

Any advice?

###################
* Installing *source* package 'gsubfn' ...
** R
** demo
** inst
** preparing package for lazy loading
Warning: S3 methods '$.tclvar', '$<-.tclvar', 'as.character.tclObj',
'as.character.tclVar', 'as.double.tclObj', 'as.integer.tclObj',
'as.logical.tclObj', 'print.tclObj', '[[.tclArray', '[[<-.tclArray',
'$.tclArray', '$<-.tclArray', 'names.tclArray', 'names<-.tclArray',
'length.tclArray', 'length<-.tclArray', 'tclObj.tclVar',
'tclObj<-.tclVar', 'tclvalue.default', 'tclvalue.tclObj',
'tclvalue.tclVar', 'tclvalue<-.default', 'tclvalue<-.tclVar' were
declared in NAMESPACE but not found
Error in namespaceExport(ns, exports) :
  undefined exports: addTclPath, as.tclObj, is.tclObj, is.tkwin
Error : package 'tcltk' could not be loaded
ERROR: lazy loading failed for package 'gsubfn'
* Removing '/g/bork3/x86_64/lib64/R/library/gsubfn'

The downloaded packages are in
        '/tmp/RtmpkfvT5f/downloaded_packages'
Updating HTML index of packages in '.Library'
Warning message:
In install.packages("gsubfn", lib = "/g/bork3/x86_64/lib64/R/library") :
  installation of package 'gsubfn' had non-zero exit status

########## this is the error when I tried to install tcltk#
install.packages("tcltk")
Warning message:
In getDependencies(pkgs, dependencies, available, lib) :
  package 'tcltk' is not available



On 03/09/10 16:26, Gabor Grothendieck wrote:
> On Tue, Mar 9, 2010 at 7:10 AM, alison waller <alison.waller at embl.de> wrote:
>   
>> Hi all,
>>
>> Thanks for help with the paste and sprintf syntax.
>>
>> So I've decided to use paste and or sprintf.  'gsubfn' looks like a
>> great package but unfortunately I've had problems installing it, as I
>> don't think it likes the version of tcltk that is installed.  I'm
>> working on a few unix clusters with many computers and there seems to be
>> problems with different versions of R and different versions of the
>> packages on different computers.
>>     
> The fn$ functionality that I mentioned does not use the tcltk package
> so the version of tcltk should not matter.
>
> The only part of the package that uses tcltk is strapply, which is not
> used here, and even in that case there is R code to it as well if you
> use strapply(..., engine = "R") or use ostrapply.
>
> Also the older 0.3-9 version of the gsubfn package did not use tcltk at all.
>