[R] using R variables in RMySQL query

[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_ID
WHERE (price.date_holding BETWEEN 'startdate' AND 'enddate') AND
stocks.stock_ticker_yahoo IN ticker";)

}

I get all sorts of errors. I want to pass variables startdate, enddate and
ticker. It would also be nice to pass the username, password and dbname
information in the function. 

I have read through a few posts here regarding using "paste" but I still get
errors. Can someone point me in the right direction please? Thank you very
much.


--
View this message in context: http://r.789695.n4.nabble.com/using-R-variables-in-RMySQL-query-tp3399978p3399978.html
Sent from the R help mailing list archive at Nabble.com.