Re: [R] using R variables in RMySQL query

2011-03-25 Thread Uwe Ligges
On 23.03.2011 17:44, algotr8der wrote: I have the following function myGetstockdataMySQL<- function(startdate, enddate, ticker) { con<- dbConnect(MySQL(), user="blahblah", password="blahblah", dbname="blahblah", host="localhost") rs<- dbGetQuery(con, "SELECT price.close FROM price INNER JOI

[R] using R variables in RMySQL query

2011-03-23 Thread algotr8der
I have the following function myGetstockdataMySQL <- function(startdate, enddate, ticker) { con <- dbConnect(MySQL(), user="blahblah", password="blahblah", dbname="blahblah", host="localhost") rs <- dbGetQuery(con, "SELECT price.close FROM price INNER JOIN stocks ON stocks.stock_id=price.stock_