[R] Reference a variable inside a string and another for object assingments

Hi R community I copied a bit of my R code that gets some data from a database. You won't be able to run the code, but I am a beginner so you will probably understand what going on. I would like to make a variable I can refer to inside the sqlQuery. Instead of writing the start date and time (ex

Re: [R] Reference a variable inside a string and another for object assingments

7;, '2012-06-12 23:14', sql) ) > > > > Or if mydates is a vector of dates stored as a POSIXt object: > > for (id in mydates) { > dbGetQuery( con, gsub('ADATE', format(id), sql) ) > } > > > -Don > > -- > Don MacQueen > > Lawrence Liv

Re: [R] Reference a variable inside a string and another for object assingments

Thanks Gabor! This is exactly what I was searching for! --- And it works like a charm. On Fri, Aug 17, 2012 at 1:03 PM, Gabor Grothendieck wrote: > On Thu, Aug 16, 2012 at 3:30 PM, Kenneth Rose wrote: >> Hi R community >> >> I copied a bit of my R code that gets some data